Building SQL ConstantCare®: Analyzing Query Plans

Starting to translate sp_BlitzCache into the cloud.

Query Plan Oddities: Two Identical Missing Indexes

Brent demos a single query plan that asks for 2 identical indexes on the same table.

Live Query Plans and Blocking

Erik Darling looks at how SQL Server 2016's live query plans react when they're blocked.

Retrieving SQL Server Query Execution Plans

Execution plans explain all you need to know about query performance, and how to fine-tune. Sure, you can see them in SSMS, but what if you need to drill into to the important details? What about using DMVs, Extended Events or SET statements to get at the execution plans? To get the best use of execution plans you need to be able to get right information from the right plan at the right time. Robert Sheldon explains how.

SQL Server 2016 Temporal Table Query Plan Behaviour

In this latest T-SQL Tuesday, Rob Farley takes a look at a couple of unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.

Number of Rows Read / Actual Rows Read warnings in Plan Explorer

Rob Farley looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.

SQL Server 2016 Temporal Table Query Plan Behaviour

For this month's T-SQL Tuesday, Rob Farley takes a look at a couple of unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.

Correct SQL Server TempDB Spills in Query Plans Caused by Outdated Statistics

Sergey Gigoyan looks at how to address the warning: Operator used tempdb to spill data during execution with spill level 1.

Exploring Query Plans in SQL

SQL Server keeps the most-used execution plans in cache, so it doesn't need to recompile the same queries every time. How can we benefit from this to find potential performance problems in execution plans?

Query Plan Execution Order