I recently asked on Twitter an exciting question about OR vs IN. While I got lots of good answers, there were an equal amount of wrong answers.
SQL Server: How to Display Row Numbers in Query Editor for Efficient Query Editing
Let us learn how to Display Row Numbers in Query Editor for Efficient Query Editing. Comprehensive Database Performance Health Check
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 – 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 – 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).
SQL SERVER – Change Join Type for Query
“Can I Change Join Type for Query?” I was recently asked this during Comprehensive Database Performance Health Check. Of course Yes!
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.