The previous chapter was focused on ensuring that your queries were able to take advantage of the indexes in your database. In this chapter, we’ll be focusing on ensuring that we reduce the resource use of our queries. There are mechanisms with T-SQL that are more likely to use up memory, CPU, and I/O. Focusing on writing our queries in such a way as to reduce resource use not only helps individual queries but reduces the overall load on the system. We’ll examine a number of different techniques ...
© 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_1515. Reduce Query Resource Use
Grant Fritchey1
(1)
Grafton, MA, USA
Get SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
