Skip to main content

Microsoft Virtual Academy: Breakthrough Insights using SQL Server 2012 : Scalable Data Warehouse and Beyond Relational (Module 3) - Using Columnstore Technology to Revolutionize Data Warehouse Query Performance


About This Video

This talk describes a new data warehouse SQL query acceleration feature in Microsoft SQL Server 2012 based on a new type of index called the columnstore. This new index,combined with enhanced query processing features,improves data warehouse query performance by hundreds to thousands of times in some cases,and can routinely give a tenfold speedup for a broad range of decision support queries. We describe the fundamentals of column store technology, and how to create applications using it in Microsoft SQL Server 2012. We also describe how you can migrate your existing decision support applications to this amazing new capability.

This video is part of the Microsoft Virtual Academy (MVA), The MVA is a free program delivering structured learning paths for IT Professionals on various Microsoft products and solutions.

After watching this video, visit:

mva, enroll in this course and take the self-assessment. For every module you take and every self-assessment you complete, you will be awarded points. These points build up to levels and the higher the level you achieve, the more opportunities you have to participate in MVA offers.


Published Date: March 01, 2012
Presented By: Microsoft Virtual Academy