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 1
Why the Optimizer Doesn't Use Buffer Pool Knowledge Paul Randal describes why the optimizer doesn’t use buffer pool contents for plan generation and details the potential dangers if it did. Paul Randal ◆ November 30, 2021 3
The Adaptive Join Threshold Paul White discusses how an adaptive join decides to use a batch mode hash join or row mode apply and includes details of the threshold calculation. Paul White ◆ November 4, 2021 0
Finding Distinct Values Quickly Paul White explains a few different ways to retrieve distinct values from a table, including some big "it just runs faster" wins in SQL Server 2019. Paul White ◆ March 17, 2020 1
The Eager Index Spool and The Optimizer Paul White looks at the Eager Index Spool execution plan operator, and the optimizer rules capable of adding it into plans. Paul White ◆ November 22, 2019 0
Nested Loops Joins and Performance Spools Paul White on performance spools, and how they can be used by the optimizer to reduce the estimated cost of nested loops joins. Paul White ◆ September 25, 2019 2
Batch Mode Normalization and Performance Paul White takes a deep-dive look at the internals of batch mode data normalization and how it can affect execution plans and performance. Paul White ◆ September 5, 2019 1
