PASS logo

November 15-18

Seattle & online

2021 Summit video library

Tackling Monster Stored Procs

Allen White

What do you dread hearing from users? “The database is slow.”

What might you dread even more? Realizing the problem is related to stored procedures that are hundreds (thousands?!) of lines long. Sometimes it is a single query, with more subqueries, left joins and outer applies than you know what do with.

Where do you start? This session will walk through a methodology that has worked in a number of companies in improving performance without having to change the front-end application.