embed embed share link link comment comment

Embed This Video close
Share This Video close
bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark
embed test
Rate This Video embed
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Tags For This Video tags
rate rate tags tags related related lights lights

Make Your SQL Server Queries Go Faster

NOTE: We lost audio for the last demo (15 min).

Speaker:

John Sterrett

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.

Bio:

John Sterrett is an Independent Consultant and Group Principal at Linchpin People. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, including PASS Summit, SQL Rally, 24 Hours of PASS, SQL Saturdays, PASS Chapters, and Virtual Chapter meetings. John is a PASS Regional Mentor and leader of CACTUSS (Austin SQL User Group) and the HADR Virtual Chapter. John also blogs at http://johnsterrett.com

Recorded At:

Austin .NET User Group

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>