Watch Brent Tune Queries [Video]
Ever wonder how somebody else does it? Watch over my shoulder for this beautifully recorded one-hour session at SQLRally Nordic in Copenhagen from a couple weeks ago:
The resources, scripts, and my Be Creepy process are all free too. Enjoy, and check out all of the session recordings for even more free learnin’.
Related

Hi! I’m Brent Ozar.
I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too.
Get Free SQL Stuff
"*" indicates required fields

4 Comments. Leave new
Great stuff!
Extremely helpful!
Great advice, this would have been helpful yesterday. I look forward to using it in the future. 😉
Thanks Brent, it was interesting to watch you work through this.
I particularly liked the point that creating an index might be a quick solution, but it shouldn’t be the first solution.
Your Go link for ssms is out of date: https://www.brentozar.com/go/getssms
points to: Microsoft® SQL Server® 2012 Service Pack 1 (SP1) Express
SQL 2014 link: http://www.microsoft.com/en-us/download/details.aspx?id=42299