SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

G. FritcheySQL Server 2022 Query Performance Tuninghttps://doi.org/10.1007/978-1-4842-8891-7_21

21. Intelligent Query Processing

Grant Fritchey¹  

(1)

Grafton, MA, USA

 

As you have seen throughout the book, query tuning isn’t easy. Microsoft has recognized this and has introduced a large number of automatic performance enhancements into SQL Server over the last three versions. These are all mechanisms to attempt to deal with common query performance issues without forcing people to rewrite their code or restructure their databases. There are many ways that Microsoft can use the internals of the engine to deal with what would have been in the past problematic ...