PASS logo

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.

Get the latest

Sign up to stay up to date with news, special announcements and educational content.

Redgate will only contact you about PASS Data Community Summit unless you separately request emails about Redgate.