Getting Wait Stats

Using Filtered Indexes

Monica Rathbun fills us in on filtered indexes: Wh...

Bad Guesses and Bad Choices: Better Living Through Indexes

Batch Cussidy In the last post, we looked at how S...

Predicate Execution Order on Mixed Data Type Columns

Watch this week’s episode on YouTube. SQL Server...

Bad Guesses and Bad Choices

Let’s Run A Cruddy Query We’ve got no supporti...

Distinct Rows, And The Columns You Choose

Footnote I have two queries. They return the same number of rows. The only difference is one column in the…

Should Optimistic Be The Default Isolation Level?

Two Words Alright, I’ve lied to you already. There are way more than two words involved, here. I recently had…

Queries with RECOMPILE and Query Store

  Last week in our IEPTO2 class I was asked about queries with RECOMPILE and Query Store. Specifically: Do queries that have the OPTION (RECOMIPLE) hint go into Query...

SQL Server 2017: here a NUMA, there a NUMA...

The first unexpected behavior is one that may already be familiar to many.  [Max server memory] is not as often a maximum for SQL Server [total] memory as it...

SQL SERVER – Get Last Known Actual Execution Plan for a Previously Cached Query Plan

This feature works with SQL Server 2019 and onwards. If you are using an earlier version of SQL Server this feature will not work and will give you an...