http://www.sqlservercentral.com/blogs/sqltact/2012/10/11/performance-tuning-presentation-from-october-2012-brssug-meeting/ Printed 2014/12/20 08:19AM
Performance Tuning Presentation from October 2012 BRSSUG MeetingThanks to the 15+ folks who attended the Baton Rouge SQL Server User Group meeting last night! I hope everyone enjoyed "everyone gets a book" night!
I presented on SQL Server Performance tuning, which began with Michelle Ufford's article from GoDaddy on how she saw massive performance gains just by correcting columns to more appropriate data types. Here's a link to that article: http://inside.godaddy.com/scaling-database-data-types/
Then we went through database compression, indexing and execution plans, index INCLUDE structure, the missing indexes feature, how foreign keys can affect performance, isolation modes and MAXDOP.
I've uploaded all my sample scripts in a .zip file to the brssug.org website here for you to download.
Thanks for attending, see you November 14!