Make Your SQL Server Queries Go Faster

Abstract:

Have you ever developed slowly running queries and wondered how to tune them? In this session you will learn some 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.

Speakers:

John Sterrett

19 Recordings

John's experience leading large technical teams in complex environments has made him a global expert in performance and scalability. John speaks at conferences around the world on database strategy and topics related to performance tuning, development, and cloud computing. He is a Microsoft Certified Trainer, is the principal consultant and founder at Procure SQL.

Recorded At:

Austin .NET UG 56 Recordings

Recorded on:

Jan 12, 2015

More Info:

http://adnug.org/Home/january-12-2015-make-your-sql-server-queries-go-faster/