This SQL Saturday was a star-studded cast of speakers and a host of enthusiastic attendees. This was by far one of the biggest SQL Saturdays I’ve been to with over 300 people in attendance.
He also outlined his “twelve steps” (no, not *those* twelve steps. Twelve steps of tuning).
1. List all tables in query
2. Gather row counts
3. Find all filters (where/join)
4. Calculate selectivity – Don’t use logic yet. Rows/Total Rows per table/join
5. Gather info on additional columns used
6. Gather info on existing keys and indexes
7. Examine the execution plan (set stats IO on, set stats time on)
8. Record results
9. Adjust indexes for table with lowest selectivity. (the one closer to zero)
10. Re-run query and examine results
11. Repeat on next lowest selectivity
12. Continue on, reducing your logical and physical reads.
SEQUENCE – Replacing IDENTITY. This will work in-memory versus using the database to generate the next in sequence.
SSMS to become a Visual Studio “shell” and bring snippets, surround-with, and clipboard cycling.
Startup options easier to configure.
….and on and on.
Aaron said this is (in his opinion) the next logical update if you’re still on SQL 2005. “It’s worth the update”. I won’t go into much more detail as he has already posted his slides from this talk on his blog here.
Takeaways from this talk were:
Determine what’s most important to baseline and capture
Start simple, work up
Each person was given Post-Its used to “vote” their opinions. It turned into a spirited debate at points but my key takeaway was the phrase “Always never works in system design”.
The other takeaway was that they make Ketchup Pringles in Canada. Really? Ketchup Pringles?
This was the most highly technical talk of the day, and gave a lot of background of index internals.
Very very informative especially if you run Enterprise and large database systems.
The last event of the day (after the swag giveaway) was SQL Karaoke. All I have to say about this is there were some fun, and crazy individuals. However, they probably shouldn’t quit their day jobs <grin>.
Again, I would like to thank the organizers, presenters, DeVry staff, and all the attendees.
Everyone made this out-of-towner feel very welcome and my love for the SQL community grew that much more. Thanks so very much!
Share and Enjoy