Just got done with my morning session, titled ”Discovering the Plan Cache“, for SQL Saturday Chicago #211 and wanted to get out my session deck and scripts for people.  The session got pretty high marks from the attendees and people seemed to get a lot of good information and humor out of it.  Probably the best way to sum up the session was from Dustin Mueller (@sqlcheesecake)

OH: “The most important thing to do is figure out what the impact is going to be.” – @stratesql #SQLSatChi #sqlsat211

— Dustin Mueller (@sqlcheesecake) April 13, 2013

There was some unintentional innuendo with one slide as well.  On one slide there’s a photo of Olivia Newton-John from her “Let’s Get Physical” video.  I had intended to express my age from including that shot, but I chose my comment on the slide un-wisely, hehe.

And @stratesql goes *WAY* off track with the Oliva Newton-John pic… #sqlsatchi #sqlsat211

— Dustin Mueller (@sqlcheesecake) April 13, 2013

Without further ado, you can view the slide deck here or you can download the deck with the demos included (Discovering the Plan Cache (SQLSat211)).

Since there was a lot of interest, I’m planning to write a few new blog posts on the demos covered in this presentation in the next week, be sure to get those sent to you right away by subscribing for e-mail updates in the upper right-corner of the page.

Additional information: http://www.jasonstrate.com/resources/plan-cache/