The SQL Server Customer Advisory Team handles tons and tons of large deployments and they try to go ahead and document all their findings for the benefit of the larger community. Their whitepapers are generally loaded with loads of information that I have had instances where I used to read the article 2-3 times to get the facts and reasons behind their suggestions. Just listing some of these for your reference, do bookmark and read them when time permits –
The Analysis Services 2008 Performance Guide
Data Compression: Strategy, Capacity Planning and Best Practices
The Data Loading Performance Guide
Disk Partition Alignment Best Practices for SQL Server
Enterprise Policy Management Framework with SQL Server 2008
High Availability and Disaster Recovery at ServiceU: A SQL Server 2008 Technical Case Study
Implementing a SQL Server Fast Track Data Warehouse
Service Broker: Performance and Scalability Techniques
Tuning the Performance of Change Data Capture in SQL Server 2008
The whitepapers around Fast Track Data Warehouse are the recent ones but each and every whitepaper does give you a good read with time well spent.
This entry was posted on Wednesday, October 7th, 2009 at 16:29 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.