Today, we are going to see one more trick from the book – Remove Key Lookup and improve the performance of queries.
SQL SERVER – Source Database in Restoring State
A Source Database in Restoring State can follow a tail-log backup WITH NORECOVERY. A customer encountered this while restoring another copy.
SQL SERVER Agent Missing from SSMS
Agent XPs can explain why SQL Server Agent is Missing from SSMS. I check edition and service state before changing configuration.
SQL SERVER – Easiest Way to Copy All Stored Procedure Definitions
Object Explorer Details helps copy procedure definitions through SSMS scripting. I select the procedures and review the generated script before execution.
SQL SERVER – Stored Procedure Timing and Cached Measurements
SET STATISTICS TIME reports CPU and elapsed execution time for Stored Procedures. A customer wanted to measure a run without adding statements manually.
SQL Server – Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1)
Today we will take the same conversation to the next level by discussing Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1).
Multiple Backup Copies Stripped – SQL in Sixty Seconds #156
Yesterday I blogged about SQL SERVER – Creating Multiple Backup Copies. I got an amazing response to the blog post. Let us learn it today.