Question : I am trying to add a trigger on a production database table which includes millions of rows and […]
Tag: sql-server-2014
How do I identify the program that called a stored procedure?
Question : As part of an application database design spec, we’ve been asked to block execution of a set of […]
Why is the First Transaction Log backup of the day huge
Question : I noticed that the first transaction log backup of the day, at 0700 is like 3GB. We run […]
Batch Delete with checkpoint still causes log growth
Question : I have a large table (600 million rows, 60GB data) that I need to migrate to another table. […]
Double Concurrent Restore from one backup for 3 node AG?
Question : I have a 400GB database on SQL 2014 Enterprise Edition Instance. I took a full backup as a […]
SQL Server 2014 AG Listener
Question : I have built a two node SQL Server 2014 Always On cluster on the same subnet. I need […]
Unable to understand correlation between MaxWorkers created and CPU utilization
Question : I am having a strange issue which i am unable to understand: On my server with 64 Logical […]
Implementing gMSA account for SQL FCI
Question : I have a question on implementing gMSA account for managing authentication to SQL server. Our goal is to […]
Adding two more columns to existing script (backup summary)
Question : Can anyone help me to add two more columns to the existing code? I am not a core […]
Max Workers available and yet pending task high
Question : While exploring the data from system health extended events for event so server diagnostics I see for column […]