Brent Ozar
brentozar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com.
SQLBits 2014
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 and tries various techniques to make them faster.
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:
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