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.
SQL SERVER – Finding Queries Using Particular Index
One of the most popular questions I received during my Comprehensive Database Performance Health Check is Finding Queries Using Particular Index.
SQL SERVER – 3 Queries to Detect Memory Issues
One of the most popular conversations during Comprehensive Database Performance Health Check is about CPU and memory issues.
SQL SERVER – Cached Data Per Object in Memory
“How to build a list of cached data per object in memory pool?” I just received this question from my client who hired me for Health Check.
SQL SERVER – List Tables with Size and Row Counts
Today we will see a very simple script that lists table names with the size of the table and along with that row counts. Let us learn it in today.
SQL SERVER – sp_who2 Parameters
One of my clients asked me a follow-up question in the Comprehensive Database Performance Health Check. The question was about sp_Who2 parameters.