PASS Community Summit 2008: Program Sessions (Business Intelligence)

SQL Server 2008 introduces many new functional and performance improvements for data warehousing. This talk discusses how to use the features of SQL Server 2008 to get great performance as your data warehouse scales up, focusing on the SQL Server relational DBMS. 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. We cover techniques to improve manageability and performance at high scale, encompassing data loading (extract-transform-load, or "ETL"), query processing, hardware selection, storage configuration, partitioning, index maintenance, compression, indexed view (aggregate) management, and backup and restore.

Register Now for PASS Community Summit 2008!