1.5 The Tuning Robots in SQL Server 2017, 2019, and 2022

Each new version of SQL Server has brought a few new automated performance tools: adaptive joins, adaptive memory grants, interleaved execution for MSTVFs, and “automatic tuning” (which is a laughable name given what the feature actually does.) We’ll talk through what each feature does and what it requires, and you’ll see why it didn’t fix...