This presentations 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 your data warehouses perform the more scalable they tend to be. We look at the optimizations that were made to data warehousing, including improved parallelism and star join optimizations. We then look at the new features that target the performance of data warehouse systems and help you achieve better scalability, including data compression and a new query feature called Grouping Sets.
[youtube zSDP3FC9uO0]