xVelocity Memory Optimized Columnstore indexes: A Gem of SQL Server 2012
April 18, 2012 at 3:06 PM
—
Steven Wang
I was presenting at Auckland SQL User Group for the titled session.
Abstract:
The columnstar indexes, formerly known as project "Apollo", are new future of SQL server 2012. Columnstore indexes deliver the blazing-fast query performance, particularly for the star-joining queries. It is not surprised to notice a query performance increase up to 100 times faster. In this session, Steven will take you through the nitty-gritty and internals of columnstore indexes; he will also talk though the columnstore index do's and don'ts, limitations, tips and tricks, and the possible impact on the future BI solution considerations.
Thanks for all attendants!
I have attached the slides deck and SQL code in this blog.
ColumnstoreIndex_SQLUserGroup.pptx (1.46 mb)
SQL_Scripts.zip (15.09 kb)