SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance - Grant Fritchey

Descriere

Covers cutting-edge features like Query Store, adaptive execution plans, automated tuning in Azure. Current with SQL Server 2017, while also covering older editions back to 2012. Alerts you to changes in the cardinality estimation and query optimization engines that can lead to poor performance. Describes new tooling introduced in SQL Server 2017 SQL Server Management Studio.