3.4 SQL Server 2017 & 2019’s New Robots

SQL Server 2017 and 2019 bring 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 any of…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM or Mastering Query Tuning, or log in if you already shelled out the cash.