Let us learn how to Display Row Numbers in Query Editor for Efficient Query Editing. Comprehensive Database Performance Health Check
Remove Key Lookup – SQL in Sixty Seconds #194
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 client whom I often help with Health Check recently reached out to me with an interesting problem about Source Database in Restoring State.
SQL SERVER Agent Missing from SSMS
Comprehensive Database Performance Health Check. Recently I had a very interesting experience where SQL SERVER Agent was Missing from SSMS.
SQL SERVER – Easiest Way to Copy All Stored Procedure Definitions
What is the easiest way to copy all stored procedure definitions for your database? Well, let us quickly learn that today.
SQL SERVER – Execution Time of Stored Procedures
How to measure the execution time of the stored procedure when it contains lots of statement inside of it. Let us learn today about Stored Procedures
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).