Today we will see a very simple script that I often use during my Comprehensive Database Performance Health Check. Let us find Total Sessions By Database.
Earlier I had written a blog post SQL SERVER – List Tables with Size and Row Counts. Jason Horner, an SQL Server Expert, improved my query.
Earlier I wrote about SQL SERVER – MAX Columns ID Used in Table and lots of people asked me to create a video on this topic. Let us see the video.
The challenge I face is that often DBAs ask me to prove that indexes are really not used by queries. Let us learn about Queries Using Specific Index.
One of the most popular questions I received during my Comprehensive Database Performance Health Check is Finding Queries Using Particular Index.