SQLCat white papers a must read for performance and scalability
I've just been reading some of the
SQLCustomerAdvisoryTeam blog pasts and whitepapers. These are a must for any one
looking at performance and scale. Whilst many of these are based on experience
with the largest systems, most reccomendations apply across the board.
The website is www.sqlcat.com and the
blog is http://blogs.msdn.com/sqlcat
and http://blogs.msdn.com/sqlperf/
These are the whitepapers
The Analysis Services 2008 Performance Guide
The Data Loading
Performance Guide
Disk Partition Alignment Best Practices for SQL Server
Enterprise Policy Management Framework with SQL Server
2008
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 data loading one is just awesome.
-