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