SQL Server Best Practices

SQL Server - Best Practices
http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx

---

  
Technical White Papers

Deep level technical papers on specific SQL Server topics that were tested and validated by SQL Development

•SQL Server 2005 Performance Tuning using Waits and Queues

•Analysis Services 2005 Performance Guide

•SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Performance, and Scalability

•Microsoft SQL Server 2005 Tuning Tips for PeopleSoft8.x

•DBCC SHOWCONTIG Improvements and Comparison between SQL Server 2000 and SQL Server 2005

•TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild

•Loading Bulk Data into a Partitioned Table

•Database Mirroring Best Practices and Performance Considerations

•Troubleshooting Performance Problems in SQL Server 2005

---

Best Practices ToolBox

•Scripts and tools for performance tuning and troubleshooting SQL Server 2005

•Buffer Cache

•CPU and Optimization

•Indexes and Indexing

•IO

•Performance

•Query Plan Re-Use

•Retrieving SQL Text and XML Plans

•SQLOS: Schedulers, Runnable Queue, Waiter List

•Tempdb

•Transactions and Locking

•Wait Statistics

---

Top 10 Lists

Summary lists (usually consisting of 10 items) of recommendations, best practices and common issues for specific customer scenarios by the SQL Server Customer Advisory Team.

•Storage Top 10 Best Practices

•OLTP Top 6 Performance Issues for OLTP Applications

•Top 10 SQL Server 2005 Performance Issues for Data Warehouse and Reporting Applications

•Top 10 Hidden Gems in SQL Server 2005

---

Best Practices in SQL Server Books Online

•Best Practices for Replication Administration

•Replication Security Best Practices

•Best Practices for Recovering a Database to a Specific Recovery Point