Questions tagged [sql-server-2014]
SQL Server 2014 (major build version 12.0.xxxx). Please also tag sql-server.
2,745
questions
1
vote
1
answer
43
views
Transactional Replication row data inconsistency
I am seeing data inconsistency in row count Transactional Replication. Subscriber is having 20 rows extra. The agent profile is used continue on data consistency error. The replication is working fine....
0
votes
0
answers
28
views
Reinitialize Transactional replication which is 5 months behind
I have given new server recently and found one of of the publication - subscription is out of sync and Distributer agent stopped as well. After checking with the team, looks like they wanted this and ...
0
votes
0
answers
16
views
Move Replication snapshot folder and Distribution database from C to another drive
I am planning to move Replication snapshot folder and Distribution database from C to another drive. Following is what I read blog post.
My setup - Both Distributor and publisher are in same server.
...
0
votes
0
answers
17
views
Transactional replication initialize from database snapshot spare file?
I would like to know, is it possible to initialize transactional replication from database snapshot spare file for existing replication which is inactive and expired default more than 72 hours.
I have ...
0
votes
1
answer
49
views
Joining SQL 2016 to a one-node cluster that has SQL 2014 installed
I have currently 1-node (it's a lab) Windows 2012R2 cluster with SQL server 2014 installed (patched to the last patch based on sqlserverupdates.com). The goal is to upgrade the cluster
to something ...
0
votes
1
answer
37
views
Why do I need to create endpoints after configuring a aoag?
So recently on new servers we are building, after creating the aoag and add servers, they don't go in sync, and I need to manually run this:
CREATE ENDPOINT Hadr_endpoint STATE=STARTED
AS TCP(...
0
votes
0
answers
51
views
Performance issue on same identical database with same execution plan
Need some help advise on one of the issues that we have bee working on.
For one of our SQL databases (SQL2014) we use database mirroring ( i know its old but we are working on migration) and there is ...
0
votes
0
answers
49
views
SQL Server unexplained network traffic gaps in traced events
This appears to have started happening a week, maybe two weeks ago.
Essentially, we cannot figure out whether it is the server or the client that is periodically pausing between SQL statements. In the ...
0
votes
0
answers
35
views
SQL Server SSIS Data Flow Task: How to enable transactions between two machines while bypassing DTC, if one machine does not have DTC support?
A bit of a conundrum here; I'm trying to survey what are my best to worst-case options.
For a given SSIS package, I have a Data Flow Task which connects via OLE DB for both the Source and Destination ...
0
votes
1
answer
177
views
No catalog entry found for partition ID in database 7
I would like some help to fix the database problem.
I went to restore a database and I couldn't, so I executed DBCC CHECKDB (N'DATABASE_NAME') and the following result is displayed:
CHECKDB found 0 ...
0
votes
0
answers
28
views
Session locking nonstop other sessions
so Suddenly we have a NULL session locking everything else.
the rows goes on if the server are left for some minutes running.
DBCC INPUTBUFFER returns "No Event".
sp_who2 says background,...
2
votes
1
answer
163
views
Cursor loop all users all databases
so I'm messing around tyring to code a cursor to loop through all users and drop them for all databases.
this is the code that obviously doesn't work, because i'm cracking my head on the logic to grab ...
2
votes
1
answer
259
views
Adding a leading zero to single digits in a comma separated string of numbers
I have a table with two columns. ID and VALUE. The VALUE column contains a combination of a string of numbers from 1 to 45. EG :-
ID
VALUE
T123
1,6,7,9,17,22,43
T456
2,3,5,7,8,13,28,32,41
T789
...
0
votes
1
answer
37
views
How to Schedule Run query hourly
I have MSSQL Server Express 2014 Edition. Is it possible to schedule a query to be run by hourly?
As I want it to clean up the audit trail records.
Please kindly assist me.
3
votes
2
answers
291
views
Merge join asks for seemingly unnecessary sort before joining
I use one table to update another table. Both the tables have a clustered index where the first 4 columns are the same type of data.
CREATE UNIQUE CLUSTERED INDEX [...
0
votes
0
answers
146
views
SQL Database not working after OS upgrade
Let me begin by saying I’m a noob with anything SQL.
So I was tasked to upgrade the OS on a VM running Server 2012 R2 with SQL Server 2014 Services running on it. Mainly, there is an internal website ...
0
votes
0
answers
41
views
Lost SQL 2014 installation media and needing to install on new server
We have an on-site installation of SQL 2014 that we want to move to a new server. We are no longer engaged with the company that did the original installation. We can not find any media/installation ...
0
votes
0
answers
248
views
Issues deploying SSRS related to permissions
I'm tryingto deploy a package (from a Visual studio 2017 ) and I'm receiving this error:
TITLE: SQL Server Integration Services
A .NET Framework error occurred during execution of user-defined
...
3
votes
1
answer
172
views
Trace database query
I need an advice.
I would need to trace one particular procedure in SQL Server. It happens to me that one procedure ends up with a timeout and I need to find out which select, insert or update this ...
0
votes
0
answers
115
views
Linked server query occasionally returns results slowly
I have an unfortunate situation where I need to pull a next-number from a table from both a local and a linked server. To do so, I've created a stored procedure to return the result. When I execute ...
1
vote
0
answers
122
views
SSRS 2014 Report parts and Subreports redirects to http: instead of https:
I am looking to find a solution for the SSRS 2014 server redirects to http url instead of https for all the subreports and other report parts like subscription , security , datasources etc .
What I ...
0
votes
0
answers
63
views
Cannot run a Linked server to a AASA instance using any ther login that it's not a windows acc
I created a process to run some validations on a SSAS instance from my SQL Server instance.
It works great with my windows account, but using Local accounts (user/pass) I got the famous error:
Cannot ...
2
votes
2
answers
602
views
Security Considerations/Risks/Best Practices for Enabling CLR Integration (Assemblies) for SSIS Catalog
The major pre-requisite in utilizing SSIS Catalog is enabling CLR Integration. The instance in question is running SQL Server 2014. I'm looking for feedback and resources I can mine which specifically ...
10
votes
1
answer
1k
views
SELECT Statement with , * in column list is faster than same statement without *
Situation
When querying a database with a SELECT statement with a defined set of columns, the results are received in around 21 seconds.
If there is an additional asterisk (, *) at the end of the list ...
0
votes
1
answer
63
views
Are SQL Server 2014 Security Updates Cumulative
I know this question may have already been partially answered. My questions are as follows.
Are SQL Server Security Updates cumulative ?
On https://sqlserverupdates.com/sql-server-2014-updates/ ...
0
votes
1
answer
169
views
How does SQL Server know not to execute Anchor element in Recursion CTE for 2nd Iteration / 1st Recursion?
I've been reading up on the inner workings of CTE Recursion and I'm still not quite sure how SQL Server is implementing the Anchor element in their source code and how SQL Server Query Execution ...
3
votes
1
answer
123
views
Improving query response speed when joining a non-spatial table with a spatial table on a non-spatial column
I have a table of frequently updating events that affect certain geometries. The geometry areas are fixed, but there may be an event affecting multiple areas at once, so there's a many-to-many ...
4
votes
2
answers
1k
views
Is SQL Server able to use internal parallelism for an update statement?
I am struggling to find the best way to migrate some "varchar" columns to "nvarchar". One of the options i am using is to add new nvarchar column(s) then update the values from the ...
1
vote
1
answer
546
views
Enforce password policy after creating a login
Lets say I created an SQL login with a password that does not adhere to the AD password policy without checking "Enforce password policy" option. After creation, I go back and check the box....
2
votes
1
answer
72
views
Forwarding SQL Server Error Logs to Another Server
I wasn't sure where to post this question. If this is not the right place, kindly point me in the right direction.
We have SQL Server 2012 and 2014 on-prem. My intention was to forward the error logs ...
0
votes
0
answers
101
views
Is there a built-in field or other way to put the rdl date/time stamp on a SSRS report template?
I've put the built-in fields for the report server and the report name at the bottom of my reports. I want to also put the date/time stamp of the report's .RDL file on it so we can see if the report ...
0
votes
0
answers
299
views
SQL Server Install/Uninstall Freezes
I'm running Windows Server 2019 Standard. All Windows updates have been installed. Chckdsk, sfc, and dism have been run and found no problems. Server has been restarted.
I'm trying to uninstall some ...
0
votes
2
answers
227
views
"last time index was used" showing many columns. "not used indexes" showing one column, with 0 reads
So I got this query to check unused indexes:
SELECT OBJECT_NAME(s.object_id) AS 'Table Name',
i.name AS 'Index Name',
i.index_id,
user_updates AS 'Total Writes',
...
2
votes
1
answer
647
views
How best to resolve excessive Transaction Log size
I understand excessive Transaction Log growth is a very common issue, and has been asked and answered many times. (Why Does the Transaction Log Keep Growing or Run Out of Space?) I also know the exact ...
1
vote
1
answer
73
views
Can't drop and recreate FK in SQL
I have a DBCC check that will always fail with the following error:
Msg 8992, Level 16, State 1, Line 2
Check Catalog
Msg 3853, State 1:
Attribute (referenced_object_id=517752334,key_index_id=1) of ...
0
votes
0
answers
92
views
SERVER_OPERATION_ENCRYPTION_LEVEL missing from SSISDB catalog_properties
I'm using MSSQL 2014 (build 12.0.6439.10, named instance) with SSIS 12.0 and trying to execute a package that I've successfully imported into the SSISDB catalog, but when I attempt to run it via a SQL ...
0
votes
0
answers
238
views
SQL Server FILESTREAM Object Garbage Collection in a Always On Availability Group
We have a production SQL Server 2014 running on FILESTREAM with Always On Availability Group.
It has been about 4 years since the servers go live. Recently, we encounter a hard disk space issue on the ...
0
votes
1
answer
32
views
How to model/query this data problem? Is this a timeseries issue?
We have a large amount of data in a MS-SQL2014 (v12) server.
We need to determine if a product was for sale in some time period.
For example, was this inventory for sale in the month of July 2022? (...
6
votes
2
answers
385
views
SQL Server generating sporadic Memory Dumps
We're running a 2014 SQL Server. For the past couple of years, the server generates memory dumps with no rhyme or reason, every 2-7 days, locking up most processes, and forcing us to restart the SQL ...
0
votes
2
answers
86
views
How to limit which NUMA nodes are used by SQL Server / SSRS?
I have SSRS and SQL Server running on same physical server (2 NUMA nodes).
How do you configure SQL Server and SSRS to use separate NUMA nodes?
I just didn't want SQL Data Engine to potentially ...
0
votes
1
answer
93
views
Dynamic Quorum behaviour with a witness
I was going through this article and trying to understand the behaviour described in the article.
Summary - It is not a common scenario to see cluster nodes go offline
until the last node and the FSW ...
3
votes
0
answers
73
views
Estimates badly wrong on empty string, but not specific value - SQL 2014 or earlier
Update: I went down the rabbit hole and came out understanding that this is a bug in 2014. It can be replicated on SQL Server 2019 in compatibility level 120 (2014) but if you flick the compatibility ...
3
votes
2
answers
792
views
What ports to open for sql server behind secure domain firewall
We are trying to solve connectivity issues for one of the app trying to pull data from very secured sql server behind firewall. I am not that expertise in security but need help on how to proceed in ...
0
votes
1
answer
65
views
Dell Server Raid 1 drive quick replacement with 2 exact copies
Apologies if I am posting this to the wrong place.
We are unfortunately having to handle our own server administration in-house and no one here is an expert at servers in any way! (we are web app ...
6
votes
3
answers
623
views
How to write script to kill MS Office database locks in MSSQL
I've recently inherited a MSSQL database as our DBA has moved on to greener pastures. I'm not a DBA and have limited to moderate SQL knowledge but have had to absorb some of his duties and have an ...
0
votes
1
answer
97
views
Restore from Azure Storage DB to sqlserver 2014
I am trying to restore the Database from Azure Storage to Sql server 2014 but getting the error
"TITLE: Microsoft SQL Server Management Studio
An exception occurred while executing a Transact-SQL ...
2
votes
2
answers
186
views
Is it possible to query total CPU load on system that is hosting SQL Server 2014+ Express?
I can get the available memory by querying the [master].[sys].[dm_os_sys_memory] view, but I haven't found anything similar for getting info about the CPU load.
I only find info about querying CPU ...
0
votes
1
answer
71
views
storing sensor historical binary data for last 720 reads (SQL Server) [closed]
I need to store binary data - online status (1,0 or NULL) of about 100k sensors. Data are refreshed every 1 hour and I need to store historical data for 30 days, which gives me 720 records per sensor. ...
0
votes
0
answers
94
views
Select MIN on Primary Key Field Using Sub-Optimal Index / Plan
I have a stored procedure that takes in a list (table variable) of IDs, and then it performs some queries to analyze the contents of the list and take the appropriate actions. One of the queries ...
2
votes
0
answers
155
views
SQL Server 2014 SP3 Backup to URL error
We have a database on a SQL Server 2014 (SP3 12.0.6433.1) and I'm trying to take a backup to Azure Blob Storage.
I have followed this document (https://learn.microsoft.com/en-us/previous-versions/sql/...