Jun 17 2013
Those who do know me, will know that I have been presenting a session this year titled “Natural Born Killers, performance issues to avoid” around the UK. The “Series” element of the title is there because I have decided to serialise the session for the benefit of those who have been unable to see it thus far.
As luck would have it SQL Relay 2013 starts today and by complete coincidence the 8 topics covered in this session tie in nicely with the 8 legs of the Relay. OK, it’s not really a coincidence, originally there were ten killers, but no matter how hard I tried I kept over running and so took two out.
The plan is to release one topic from the presentation each day of SQL Relay 2013. If you have registered for the Birmingham, Norwich or Cardiff events you will be able to see it live, so you might want to read this after the event as a reminder of everything that was covered.
Here’s the abstract:
You’ll learn simple tricks to write better code, scripts, and tables. Gain a deeper understanding of common database development and administration mistakes, and how you can avoid them.
Plus, you’ll learn how to take corrective action when:
•The optimizer isn’t using all available processors
•The database engine fails to report all the resources a query has used
•The optimizer uses the wrong plan
•Database tables cause memory issues
For those of you who were unable to make SQL Relay here are the topics I will cover over the next two weeks. I’ll update this post periodically so you can access all the posts in the series from here:
- 17th June – Statistcs
- 18th June – Table Design
- 19th June – Scalar UDF’s
- 20th June – Indices
- 24th June – Key lookups
- 25th June – Sargability
- 26th June – Table Variables vs Temp Tables
- 27th June – Parameter Sniffing