Free Fundamentals of Query Tuning Week: Part 3, How Parameters Influence Cached Plans


While you practice physical distancing (words I never thought I’d daisy-chain together), I’m giving away free SQL Server training. So far, we’ve covered building a query plan and how to find the right queries to tune. Make sure to keep up with the series – on April 1, these posts will magically disappear.

When you’re tuning queries, picking the right parameters is crucial. So often, you can tune for one particular set of parameters – only to result in different parameters performing poorly.

We’ll start with the query we used in the first module, searching user comments by location &