Make SQL Server Queries Run Faster

Have you ever developed slowly running queries and wondered how to tune your SQL Server queries? In this session you will learn some T-SQL performance tuning tips from a DBA who has a developer background. We will go over how to identify bottleneck queries and how to measure them. We will go over basic indexing concepts for improving workloads. Finally, we will cover some coding patterns that are developer friendly but are not SQL Server database engine friendly and show you how to optimize them.


SQL Server Root Cause Analysis in 10 Minutes
Download Sample Scripts
Build the Enlarged Tables


Slide Deck

5 responses to “Make SQL Server Queries Run Faster

  1. Pingback: Austin .NET SQL User Group Presentation | SQL Server Consulting

  2. Pingback: Extended Event Security Permissions | SQL Server Consulting

  3. Pingback: PASS Performance – SQLPalooza 2015! | Jan's Blog

Leave a Reply

Your email address will not be published.

For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.

This site uses Akismet to reduce spam. Learn how your comment data is processed.