Skip to main content

Performance and Query Optimizations in SQL Server 2012


About This Video

This talk covers the new columnstore feature in SQL Server 2012, which drastically improves performance for data warehouse queries. I’ll take the feature apart to not only discuss the layout of these indexes, but also their optimization with batch mode processing inside the query itself. I’ll also discuss additional query plan improvements and new query iterators and query plan warnings in SQL Server 2012.

More info on



Published Date: December 03, 2012
Presented By: Bob Beauchemin



Video: WMV | MP4 | WMV (ZIP)


Microsoft is conducting an online survey to understand your opinion of the MSDN Web site. If you choose to participate, the online survey will be presented to you when you leave the MSDN Web site.

Would you like to participate?