SQL Server 2012: Column store indexes
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!