TechNet Webcast: SQL Server 2008 R2: Data Warehouse Scaling and Performance (Level 300)
The presenter of this webcast explains how Microsoft SQL Server 2008 R2 data management software can improve the performance of data warehouse systems. Performance and scalability go somewhat hand in hand. The better that data warehouses perform the more scalable they tend to be. The presenter look at the optimizations that were made to data warehousing, including improved parallelism and star join optimizations. Then presenter looks at the new features that target the performance of data warehouse systems and help to achieve better scalability, including data compression and a new query feature called Grouping Sets.