Simple Parameterization and Trivial Plans — Part 6 Paul White concludes his series with trivial plans and when simple parameterization is considered safe or unsafe. Paul White ◆ August 4, 2022 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 1
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
How Parallel Plans Start Up – Part 5 Paul White concludes his series on starting parallel plans, summarizing how additional parallel tasks cooperate to complete plan execution. Paul White ◆ May 17, 2021 0
How Parallel Plans Start Up – Part 4 Paul White continues his deep dive into parallel plans. Part 4 covers exchange synchronization, CXPACKET waits, and parallel task opening. Paul White ◆ May 6, 2021 0
How Parallel Plans Start Up – Part 3 Part 3 of Paul White's series on parallel plans, explaining "early phases", how parallel tasks are added, and when plan timing data is set. Paul White ◆ April 20, 2021 0
How Parallel Plans Start Up – Part 2 Paul White continues his deep dive into parallel plans, explaining iterative execution, invisible profilers, and how the query scan begins. Paul White ◆ April 8, 2021 0
