SQLBits 2012

SQL Server 2012: Column store indexes

This session will present you with a fascinating behind-the-scenes deep-dive view of the new column store index feature. How do column store indexes work? How are they built? And how can they yield such enormous performance boosts to some workloads?
Ever since the inception of SQL Server, its indexes have always been based on B-trees. With SQL Server 2012, that finally changes!
A new index type is introduced: the column store index. A completely different paradigm, that can offer huge performance increases for some workloads.
In this session, Hugo will give you a fascinating "under the hood" view of this new type of indexes. How are they built, how do they work, and why do they manage to have such a dramatic impact on performance? Attend this session, and you'll find out!