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

    18 Recordings

    John Sterrett is an MCSE: Data Platform, Principal Consultant and the Founder of Procure SQL LLC. John has presented at many community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and the founder of the HADR Virtual Chapter.

Recorded At:

Recorded on:

Jan 12, 2015

More Info:

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

Tags:

  • SQL 15 Recordings