I hope everyone enjoyed my session on Making Your Queries Go Faster as much as I did planning and delivering it. If you would like to replay the demos on your time you can grab the slide and code . When you go through the demos, if you have any questions, give me a shout.

Groupby Demos and Source Codes

If I learned anything from Brent Ozar its to always provide free extra stuff when you present at conferences.  Therefore, below are some bonus videos.

First, here is a Real-World look into Automatic Tuning

Finding Top Offenders with Extended Events

Benchmarking a Query

Scalar Functions vs Table-Value Functions