CHAPTER 19

image

Reduce Query Resource Use

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 ways to write 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.

In this chapter, I cover the following topics:

  • Query designs that are less resource-intensive ...

Get SQL Server Query Performance Tuning,Fourth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.