Is it alright to use NOLOCK with DMVs? I was recently asked about this by a client during the Comprehensive Database Performance Health Check.
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.