SQLAuthority News – Scaling Up Your Data Warehouse with SQL Server 2008 R2
- by pinaldave
Data Warehouses are suppose to be containing huge amount of the data from the beginning. However, there are cases when too big is not enough. Every Data Warehouse Admin will agree that they have faced situation where they will need to scale up their data warehouse. Microsoft has released white paper discussing the same.
Here is the abstract from the Microsoft Official site:
SQL Server 2008 introduced many new functional and performance  improvements for data warehousing, and SQL Server 2008 R2 includes all  these and more. This paper discusses how to use SQL Server 2008 R2 to  get great performance as your data warehouse scales up. We present  lessons learned during extensive internal data warehouse testing on a  64-core HP Integrity Superdome during the development of the SQL  Server 2008 release, and via production experience with large-scale  SQL Server customers. Our testing indicates that many customers can  expect their performance to nearly double on the same hardware they are  currently using, merely by upgrading to SQL Server 2008 R2 from SQL  Server 2005 or earlier, and compressing their fact tables. We cover  techniques to improve manageability and performance at high-scale,  encompassing data loading (extract, transform, load), query processing,  partitioning, index maintenance, indexed view (aggregate) management,  and backup and restore.
Scaling Up Your Data Warehouse with SQL Server 2008 R2
Reference: Pinal Dave (http://blog.SQLAuthority.com)
 
Filed under: PostADay, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology