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, The Team Membership, Mastering Query Tuning, Level 3 Bundle (Live Classes, Lab VM Included) or Level 2 Bundle (Live Classes, No VM Included), or log in if you already shelled out the cash.