Author: Pinal Dave

SQL SERVER – DBCC SHRINKFILE: Page 1:26423878 Could not be Moved Because it is a Work Table Page – TempDB Files

SQL SERVER – sp_readrequest – Long Running Process

How to Find How Many Rows Each Query Returned Along with Execution Plan? – Interview Question of the Week #114

SQL SERVER – Microsoft.SqlServer.Management.Sdk. Sfc.EnumeratorException: Failed to Retrieve Data for This Request

SQL SERVER – Availability Group Missing or Deleted Automatically?

SQL SERVER – Maintenance Plan – Could not load type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageSigning100’ from Assembly

SQL SERVER – Errorlog The Server was Unable to Initialize Encryption Because of a Problem with a Security Library

SQL SERVER – FIX : Error Msg 8672 – The MERGE Statement Attempted to UPDATE or DELETE the Same Row More Than Once

How to Get Status of Running Backup and Restore in SQL Server? – Interview Question of the Week #113

SQL SERVER – PRINTing Status Using RAISERROR With NOWAIT Option

SQL SERVER – Script Upgrade – Server Principal ‘MS_PolicyEventProcessingLogin’ Has Granted One or More Permission(s)

SQL SERVER – FIX : Msg 35295, Level 16 – Log Backup For Database ‘DBName’ on a Secondary Replica Failed