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