Mining Plans : Not just for the plan cache Erin Stellato shows how to extract patterns and anti-patterns from the plan cache, Query Store, or the SentryOne database. Erin Stellato ◆ August 16, 2018 0
Simple Parameterization and Trivial Plans — Part 5 Paul White continues his series on simple parameterization and trivial plans explaining how maximum plan reuse is achieved. Paul White ◆ June 8, 2022 0
Simple Parameterization and Trivial Plans — Part 4 Paul White continues his series explaining how the parser affects simple parameterization and trivial plans. Learn more in part 4. Paul White ◆ May 20, 2022 2
Simple Parameterization and Trivial Plans — Part 3 Paul White continues his series on simple parameterization and trivial plans with a look at the information available in execution plans. Paul White ◆ April 18, 2022 2
Simple Parameterization and Trivial Plans — Part 2 Paul White continues his series on simple parameterization and trivial plans with a look at the data types assigned to parameters. Learn more in part 2. Paul White ◆ March 29, 2022 0
Simple Parameterization and Trivial Plans — Part 1 Paul White embarks on a new series covering less well-known details about simple parameterization and trivial plans. Learn more in part 1. Paul White ◆ March 22, 2022 4
How Parallel Plans Start Up – Part 1 Paul White takes a deep dive into the way parallel plans start up, including the role of the parent task (coordinator) in plan execution. Paul White ◆ March 30, 2021 2
How to Write a Query with Multiple Behaviors Guy Glanster explores the multiple behaviors of queries designed to support user-specified filtering and sorting. Guy Glanster ◆ February 16, 2021 1
A use case for sp_prepare / sp_prepexec Aaron Bertrand explains a scenario where sp_prepare came in handy trying to validate a plan guide's impact. Aaron Bertrand ◆ January 11, 2021 0
An approach to index tuning – Part 2 Erin Stellato concludes her two-part series on her multi-step approach to index tuning in SQL Server. Erin Stellato ◆ April 13, 2020 1
An approach to index tuning – Part 1 Erin Stellato walks through her multi-step approach to index tuning, with thorough explanations and simple but clever visualizations. Erin Stellato ◆ March 26, 2020 8