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
SQL Server Join Estimation using Histogram Coarse Alignment Paul White dives into histograms and explains how the optimizer uses coarse alignment for cardinality estimates. Paul White ◆ November 20, 2018 1
Cardinality Estimation for a Predicate on a COUNT Expression Paul White (@SQL_Kiwi) takes you on an optimizer journey, exploring how SQL Server comes up with cardinality estimates for COUNT queries. Paul White ◆ April 12, 2017 5
Paying Attention to Estimates Aaron Bertrand (@AaronBertrand) follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques. Aaron Bertrand ◆ July 11, 2016 0