Posted by: techsavygal | March 2, 2009

SQL Server 2005/2008 Best Practices!

Hi All,

I found a list of Best Practices available for SQL Server 2005/2008. 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

SQL Server 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


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


%d bloggers like this: