SQL Server Archives - Page 6 of 320 - SQL Authority with Pinal Dave

SQL SERVER – Logical Processing Order of the SELECT Statement

November 18, 2020

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.

November 17, 2020

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?

November 12, 2020

Comprehensive Database Performance Health Check and they asked me a question about logical read based on my previous video about SET STATISTICS IO.

November 11, 2020

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.

November 10, 2020

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.

November 9, 2020

Recently a client asked me during Comprehensive Database Performance Health Check what does it mean to see more preemptive waits on their system.

November 6, 2020

An interesting question asked by one of my clients. The question was how to have multiple optimize hints for a query. Let us learn.