Performance optimization on SQL Server can be challenging. A vast array of information is available on how to address performance problems in general. However, there is not much detailed information on specific issues and even less information on how to apply that specific knowledge to your own environment.
Co-authored by Patrick O'Keefe and Peter O'Connell, this paper offers 10 tips for optimizing SQL Server performance, with SQL Server 2008 and 2012 in mind. There are no definitive lists of the most important tips, but you won’t go wrong by starting here.