SQL Server - Best Practices
This is a great resource and I would just like to highlight it in case you missed it. Euan Garden mentioned it in passing before Christmas. The SQL Server - Best Practices Site has loads of great information there are links to Technical White papers. A whole heap of tools in the Best Practice Tool Box. Which has scripts organised by subject area such as buffer cache or CPU and optimization. You also have the Top 10 Lists which gives summary lists of best practices by customer scenario's. This is well worth a look.
