Session
Query processing in SQL Server 2022 - Inteligent++ ?
Microsoft has done a lot of work since SQL Server 2016 to make performance tuning easier. Query Store, Adaptive Query Processing, Intelligent Query Processing, and Automatic Tuning have been released in the past years. And now "NextGen Intelligent Query Processing" has been announced for SQL Server 2022. But what does this mean? What can you expect? And most important question: will ALL queries now always finish fast, or are your tuning skills still relevant?