April 18, 2012 at 5:06 AM
I was presenting at Auckland SQL User Group for the titled session.
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)
August 28, 2011 at 12:53 AM