Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [sql-server-2014]

SQL Server 2014 (major build version 12.0.xxxx). Please also tag sql-server.

Filter by
Sorted by
Tagged with
0 votes
1 answer
32 views

SQL Server Failover Cluster Data Loss on failover

Currently running several databases on an Active/Passive SQL Server 2014 Failover Cluster on Windows Server 2012 R2. Recently there was an event that caused the active server to failover. The failover ...
David Gerst's user avatar
0 votes
1 answer
42 views

Working with window patching for many SQL server with AOAG

We have hundreds of servers and 99% of them have AOAG strategy. Patching takes HOURS since we need to patch secondaries (Windows patch) , wait to complete, manually fail over to the other node, Patch ...
Racer SQL's user avatar
  • 7,386
0 votes
0 answers
27 views

Always on availability group removing nodes

We have a SQL 2014 enterprise with 4 node availability group database with 2 Synchronous commit , 1 read only Asynchronous for reporting and 1 DR asynchronous. Due to space shortage we need to remove ...
SQL_NoExpert's user avatar
  • 1,061
0 votes
1 answer
62 views

Does it make sense to schedule agent to create multiple #temp tables in parallel?

So I have this idea of scheduling sql server agent to create some #temptables in parallel before mass updating my large table (roughly 30Gb) to save some time. Currently, it took about 2 hours for the ...
D H's user avatar
  • 13
0 votes
3 answers
41 views

Active-Active Availability Group configuration

Lets say we have two node AlwaysON availability group setup and each node has an availability group as primary. EG - Cluster Nodes - Node1, Node2 Availability Group AG1 is Primary on Node 1 and ...
DMDM's user avatar
  • 1,738
0 votes
1 answer
51 views

Dropping Always On Availability Group Owners

I really tried to find info on this but all I could find was this doc: Who owns your availability groups? We have many Always On Availability Groups. All of them are owned by a past user not in a ...
Racer SQL's user avatar
  • 7,386
0 votes
0 answers
16 views

Initialized Replication Subscriber from Backup with @allow_anonymous,@immediate_sync off

I have initialized Replication Subscriber from Backup with @allow_anonymous,@immediate_sync = flase It is working good. Do I need t o change the setting back to true or just leave with false.
Saran's user avatar
  • 71
0 votes
3 answers
91 views

I could not add sp_BlitzIndex store procedure to SQL Server 2014 version

I cannot successfully add the sp_BlitzIndex store procedure for Microsoft SQL Server 2014 (SP3-CU3-GDR) and earlier versions. I think there is something related to the version. Because I was able to ...
Merve's user avatar
  • 55
0 votes
1 answer
45 views

Ideal VLF size - SQL Server transaction log

Is there an ideal size for the VLFs in a transaction log. This is a system with AlwaysON and Transactional replication. I was wondering if there is any cons to creating large VLF's. Eg, lets say ...
DMDM's user avatar
  • 1,738
4 votes
1 answer
214 views

Unique index on computed column when contributing columns are already unique

I have a table like this: CREATE TABLE dbo.DiscountBarcodeList ( ID int NOT NULL IDENTITY CONSTRAINT PK_DiscountBarcodeList PRIMARY KEY CLUSTERED , Discount int NOT NULL CONSTRAINT ...
Andriy M's user avatar
  • 23k
0 votes
1 answer
35 views

How to track whats causing DTC to keep closing the connection during a job execution?

We have a job with a few steps, and the last step is failing daily. The step is a bunch of begin transaction, inserts and etc across a linked server. I'm failing to track "what" is actually ...
Racer SQL's user avatar
  • 7,386
0 votes
0 answers
27 views

Difficulty Shrinking Large database files [duplicate]

My company's primary client database (SQL SERVER 2014) is over 8 TB in size. As part of our latest project we have moved roughly one third of the data tables to separate AG databases. We are now ...
Lumpy's user avatar
  • 2,109
0 votes
1 answer
55 views

CDC cleanup doesn't work even when using sp_cdc_cleanup_change_table which completes successfully

I'm running the query below to find CDC tables with data beyond the configured retention depth: SELECT DB_ID() AS database_id, ct.capture_instance, object_id, source_object_id , rcounts....
Eitan Blumin's user avatar
1 vote
1 answer
91 views

Need help with conditional updating of a large table (50 milions) row

My procedure is as follows: set [tb1].[SLD_VAR] = case when [CalendarDate] = [tb1].[FileDate] and ([tb2].[SLD] - [tb2].[LAG_SLD])/([tb2].[SLD]+1) >= 0.15 then 1 else 0 end, ...
D H's user avatar
  • 13
-1 votes
1 answer
63 views

What would be a good strategy for a 5tb database and index maintenance?

We use ollas index maintenance with some changes here and there done by our team. we usually have an issue with a huge database where its Alter index locks some processes. Its normally a reorganize , ...
Racer SQL's user avatar
  • 7,386
0 votes
0 answers
42 views

SQL Server 2014 Negative log. Stuck at CHECKPOINT. Unable to do anything

I have a database that is stuck at CHECKPOINT for hours and I already tried all solutions that have been suggested in this site with no avail and I'm starting to lose faith. Keep in mind that the ...
Pedro's user avatar
  • 1
0 votes
0 answers
29 views

SQL Server 2014 extended stored procedure gets stuck after Windows Server 2012 R2 updates

After running Windows Server updates (including server restart), SQL Server experienced problems executing XP_ commands. These are stuck forever without any response. The only solution I have found so ...
Victor's user avatar
  • 1
0 votes
0 answers
28 views

Comparison of rolap and molap in the tubular or multidimensional environment is better?

I want to write a comparison article on ROLAP and MOLAP, and I have installed SSAS. During the installation process, there was a Tabular section and a Multidimensional section that I needed to choose ...
Kavous's user avatar
  • 1
1 vote
1 answer
759 views

New SQL Server 2022 slower than old 2014 server

I'm planning and testing a new SQL Server 2022 install to migrate from an older 2014 database. I've noticed during performance testing some major discrepancies with some bulky queries. Here is a query ...
JulioQc's user avatar
  • 143
1 vote
1 answer
57 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....
Saran's user avatar
  • 71
0 votes
0 answers
39 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 ...
Saran's user avatar
  • 71
0 votes
0 answers
55 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. ...
Saran's user avatar
  • 71
0 votes
0 answers
20 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 ...
Saran's user avatar
  • 71
0 votes
1 answer
82 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 ...
Sranda's user avatar
  • 360
0 votes
1 answer
44 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(...
Racer SQL's user avatar
  • 7,386
0 votes
0 answers
55 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 ...
Newbie-DBA's user avatar
1 vote
0 answers
60 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 ...
孔夫子's user avatar
  • 4,330
0 votes
0 answers
82 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 ...
user3621633's user avatar
0 votes
1 answer
405 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 ...
Chris Samaritano's user avatar
0 votes
0 answers
29 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,...
Racer SQL's user avatar
  • 7,386
2 votes
1 answer
394 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 ...
Racer SQL's user avatar
  • 7,386
2 votes
1 answer
365 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 ...
UK1539's user avatar
  • 25
0 votes
1 answer
62 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.
Nadh's user avatar
  • 1
3 votes
2 answers
371 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 [...
KHP's user avatar
  • 65
0 votes
0 answers
211 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 ...
Lin's user avatar
  • 1
3 votes
1 answer
216 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 ...
Jan Kůst's user avatar
1 vote
0 answers
168 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 ...
Dave.Gugg's user avatar
  • 304
1 vote
0 answers
194 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 ...
divyasridhar's user avatar
2 votes
2 answers
922 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 ...
user3621633's user avatar
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 ...
John K. N.'s user avatar
  • 17.9k
0 votes
1 answer
103 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/ ...
steve's user avatar
  • 47
0 votes
1 answer
225 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 ...
user3621633's user avatar
3 votes
1 answer
127 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 ...
wxdan's user avatar
  • 33
4 votes
2 answers
2k 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 ...
Edward Hayrabedian's user avatar
1 vote
1 answer
1k 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....
DMDM's user avatar
  • 1,738
2 votes
1 answer
142 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 ...
Nina G's user avatar
  • 123
0 votes
0 answers
391 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 ...
socaljoker's user avatar
0 votes
2 answers
417 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', ...
Racer SQL's user avatar
  • 7,386
2 votes
1 answer
2k 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 ...
Dave Harding's user avatar
1 vote
1 answer
81 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 ...
Dominic Legendre's user avatar

1
2 3 4 5
56