Scans are not always bad they are there because they are needed. Let us see a very simple demonstration about Top 1 and Index Scan.
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.
While all other methods work fine, let us see how easily we can find this in an SSMS. Let us learn how to find a table in an execution plan.