Today I am going to share our very interesting conversation about sp_updatestats and Disabled Nonclustered Indexes. Let us discuss.
SQL SERVER – JOIN Elimination for Not Selected Column
The question is about JOIN Elimination for Not Selected Column. It was discussed in the Comprehensive Database Performance Health Check.
SQL SERVER – Disable Statistics Update for a Single Table
Recently I had encountered an interesting issue with one table where we had to disable statistics update for a single table. How we can do that?
SQL SERVER – What is Logical Read?
Comprehensive Database Performance Health Check and they asked me a question about logical read based on my previous video about SET STATISTICS IO.
SQL SERVER – 3 Different Ways to Set MAXDOP
I got lots of emails about how to set MAXDOP for any query. Today we will be learning 3 different ways to set MAXDOP. Let us learn it today.
SQL SERVER – PREEMPTIVE Waits – Simple Definition
Recently a client asked me during Comprehensive Database Performance Health Check what does it mean to see more preemptive waits on their system.
SQL SERVER – Multiple Optimize Hint for a Query
An interesting question asked by one of my clients. The question was how to have multiple optimize hints for a query. Let us learn.