The Turbo-Booster in SQL Server 2012-Columnstore Indexes
Do you want to improve your DWH query performance by 100 times by just adding one additional index? Not possible? Wrong! SQL Server 2012 provides you the new Columnstore Index which changes the paradigm for DWH queries completely. In this session we will look at the details of the new Columnstore Index, when it makes sense, when not, and what are the current restrictions of it. We will look into Row Store vs. Column Store, how to change data in tables that have a Columnstore Index defined, we talk about Segment Elimination, Batch Mode Execution, about Query Memory Grants, and finally about how you can make sure that SQL Server will use your Columnstore Index as effective as possible.
Sorry, there are no downloads available for this session.
Klaus Aschenbrenner provides SQL Server Consulting services across Europe and the US. He helps people around the world to understand, use, and run SQL Server installations in their environments. In the years 2004 - 2005 Klaus was honored with MVP awards from Microsoft for his tremendous support of the .NET Community. Klaus is also the author of the book Pro SQL Server 2008 Service Broker (ISBN 1590599993) published by Apress in August 2008.
The video is not available to view online.