A client whom I often help with Health Check recently reached out to me with an interesting problem about Source Database in Restoring State.
What is the easiest way to copy all stored procedure definitions for your database? Well, let us quickly learn that today.
Today we will take the same conversation to the next level by discussing Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1).
Yesterday I blogged about SQL SERVER – Creating Multiple Backup Copies. I got an amazing response to the blog post. Let us learn it today.
One of my long-term clients (Comprehensive Database Performance Health Check) recently asked me question if I know a way of creating multiple backup files.