Why the result we get is the result we get. The answer is very simple – it is because of the Logical Processing Order of the SELECT Statement.
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 – 16 CPU vs 1 CPU : Performance Comparison – SQL in Sixty Seconds #142
Well, let us figure out the answer to this question in today’s blog post where I will be doing a performance comparison of 16 CPU vs 1 CPU.
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.