Hi All,

While checking out some stuff on SQL Server, i stumbled on the set of Best Practices available for SQL Server 2005. Check them out here:

•          XML Best Practices for Microsoft SQL Server 2005

•          Performance Optimizations for the XML Data Type in SQL Server 2005

•          SQL Server 2005 Security Best Practices – Operational and Administrative Tasks

•          SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned

•          Scale-Out Querying with Analysis Services

•          SQL Server 2005 Analysis Services Processing Best Practices

•          Predeployment I/O Best Practices

•          Partial Database Availability

•          Comparing Tables Organized with Clustered Indexes versus Heaps

•          SQL Server 2005 Deployment Guidance for Web Hosting Environments

•          Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios

•          Implementing Application Failover with Database Mirroring

•          OLAP Design Best Practices for Analysis Services 2005

•          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

•          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 PeopleSoft 8.x

•          Troubleshooting Performance Problems in SQL Server 2005

 Also, check out some of features available 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

•  Input/Output

•  Performance

•  Query Plan Re-Use

•  Retrieving SQL Text and XML Plans

•  SQLOS: Schedulers, Runnable Queue, Waiter List

•  Tempdb

•  Transactions and Locking

•  Wait Statistics

•   SQL Server 2005 Best Practices Analyzer

•   DMV Stats

 E Enjoy!