Is it alright to use NOLOCK with DMVs? I was recently asked about this by a client during the Comprehensive Database Performance Health Check.
SQL SERVER – Find Total Sessions by Database
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.
SQL SERVER – List Tables with Size and Row Counts – Part 2
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.
MAX Columns Ever Existed in Table – SQL in Sixty Seconds #182
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.
SQL SERVER – Find High Frequency Queries
Recently during consulting engagement, we had to Find High Frequency Queries in SQL Server, let us learn that today. Let us learn today.
SQL SERVER – MAX Column ID Used in Table
Well, we discussed this during SQL YouTube Live – Performance Troubles – Execution Plans. Let us see MAX Column ID Used in Table.
Queries Using Specific Index – SQL in Sixty Seconds #180
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.