SQL Server Best Practices

  • Article

With the numbers of databases required in EPM 2007, it's key to have a well tuned and maintained database server. The following TechNet page gives a recap of all SQL Server Best Practices:

Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. These SQL Server best practices draw on the extensive experience and expertise from respected developers and engineers at Microsoft, who walk you through the specifics on solving particularly difficult issues.

The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode SQL Server 2005 Deployment Guidance for Web Hosting Environments
Precision Considerations for Analysis Services Users Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios
Scale-Out Querying with Analysis Services Using SAN Snapshots Implementing Application Failover with Database Mirroring
Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services OLAP Design Best Practices for Analysis Services 2005
XML Best Practices for Microsoft SQL Server 2005 DBCC SHOWCONTIG Improvements and Comparison between SQL Server 2000 and SQL Server 2005
Performance Optimizations for the XML Data Type in SQL Server 2005 TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild
SQL Server 2005 Security Best Practices - Operational and Administrative Tasks Loading Bulk Data into a Partitioned Table
SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned Database Mirroring Best Practices and Performance Considerations
Scale-Out Querying with Analysis Services SQL Server 2005 Performance Tuning using Waits and Queues
SQL Server 2005 Analysis Services Processing Best Practices Analysis Services 2005 Performance Guide
Predeployment I/O Best Practices SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Performance, and Scalability
Partial Database Availability Microsoft SQL Server 2005 Tuning Tips for PeopleSoft 8.x
Comparing Tables Organized with Clustered Indexes versus Heaps Troubleshooting Performance Problems in SQL Server 2005

Happy new year 2008!