Abstract
In the previous chapter you focused on writing queries in such a way that they appropriately used indexes and statistics. In this chapter, you’ll make sure you’re writing a queries in such a way that they don’t use your resources in inappropriate ways. There are approaches to writing queries that avoid using memory, CPU, and I/O, as well as ways to write the queries that use more of these resources than you really should. I’ll go over a number of mechanisms to ensure your resources are used optimally by the queries under your control.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2018 Grant Fritchey
About this chapter
Cite this chapter
Fritchey, G. (2018). Reduce Query Resource Use. In: SQL Server 2017 Query Performance Tuning. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3888-2_20
Download citation
DOI: https://doi.org/10.1007/978-1-4842-3888-2_20
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-3887-5
Online ISBN: 978-1-4842-3888-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books