Query Tuning Without Production Data

Target Audience:

DBA or Database Developer who query tunes.


The DBA is constantly ringing your phone complaining about why you did not include an index to support your new stored procedure. They have full access to production and do not understand how hard it is to tune a query with an under-powered development machine and a database which is less than 1/10th the size of the production equivalent. This session will cover query tuning techniques which will stop those phone calls and can be exercised on the worse of development environments. I will focus on query execution plan anti-patterns and faking out the optimizer.

Why I Want to Present This Session:

I have spent a lot of my career tuning queries after they become production incidents. I also have regularly heard excuses for bad queries, claiming that no tuning can occur in the lower environments. I am passionate about setting the record straight that a lot of query tuning can occur without production quality or quantity of data.

Additional Resources:

Presentation: Query Tuning Without Production Data
The following two tabs change content below.

Derik Hammer

Latest posts by Derik Hammer (see all)

Previous Post
Polybase In Action
Next Post
The extraordinary power of Python support in SQL Server

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.