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 4
Fundamentals of Table Expressions, Part 13 – Inline Table-Valued Functions, Continued Itzik Ben-Gan concludes his series on table expressions in SQL Server, explaining more internals of inline table-valued functions. Itzik Ben-Gan ◆ November 10, 2021 2
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
