An oldie but goodie–SQL Performance Turning
While looking through past performance talks and presentations I came across this talk done at a BlackBoard.com conference and since it was already in the public domain I thought it worth sharing here. Keep in mind while the tuning principles are timeless there are some cool new techniques around performance turning and monitoring in SQL 2008+ like Extended Events (XEvents ). Helping to deliver XEvents was truly a fun time.
(click the image above to see the presentation deck)