The Baker’s Dozen: What’s New in SQL Server 2012 (Part 1 of 13)—Using the New Column Store Index

Have you ever purchased or upgraded to a product because of one major, killer function? The new column store index in Microsoft SQL Server 2012 might be the one feature that convinces managers of SQL Server data warehouses to upgrade. Based on the VertiPaq technology that’s already found in Microsoft PowerPivot, the new column store index can increase the performance of data warehousing queries by a factor of 10 or more. That’s beyond significant! In this webcast, I show scenarios where you can create column store indexes and view the statistics and performance of queries with (and without) them.



Comments (0)

Skip to main content