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.

Resources

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

Video

Slide Deck