BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//SQLBits/com
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-MS-OLK-FORCEINSPECTOROPEN:TRUE
BEGIN:VEVENT
DTSTART:20140718T100000Z
DTEND:20140718T110000Z
LOCATION:SQLBits Conference - Ironbridge 1
SUMMARY:Watch Brent Tune Queries
DESCRIPTION:Ever wonder how someone else does it? There’s no right way or wrong way, but in this session, you can peer over Brent’s shoulder (virtually) while he takes a few Stack Overflow queries, tries various techniques to make them faster, and shows how he measures the before-and-after results.

You'll learn:

How to make sure you've got the right execution plan before you start

How to measure your changes as you tune the query

Why index changes should be the last thing you consider

What free tools make the process much easier

X-ALT-DESC;FMTTYPE=text/html:

Watch Brent Tune Queries

Ever wonder how someone else does it? There’s no right way or wrong way, but in this session, you can peer over Brent’s shoulder (virtually) while he takes a few Stack Overflow queries, tries various techniques to make them faster, and shows how he measures the before-and-after results.

You'll learn:

How to make sure you've got the right execution plan before you start

How to measure your changes as you tune the query

Why index changes should be the last thing you consider

What free tools make the process much easier

Brent Ozar

Brent Ozar specializes in making SQL Server faster and more reliable.

He's a Microsoft Certified Master of SQL Server and MVP, and he has over a decade of experience. He coauthored Professional SQL Server 2008 Internals and Troubleshooting, created sp_Blitz® and sp_AskBrent®, and he loves sharing knowledge at BrentOzar.com.