02. The Kinds of Queries That Are Susceptible to Parameter Sniffing

In the first example, we used a single-table query that had to make a decision between: An index seek + key lookup vs a clustered index scan Asking for a single CPU core or going parallel across multiple cores Asking for a small memory grant or a large one Now we’ll review several different kinds…

Menu