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!
Presented by Hugo Kornelis at SQLBits X
  • Downloads
  • SpeakerBIO
    hugo_kornelis.jpg

    Hugo Kornelis is an established SQL Server communiity expert who spends a lot of time at various conferences. He is also a blogger, technical editor of a variety of books, and Pluralsight author. He is a SQL Server MVP since 2006.

     

    When not working for the community, he is busy at his day job: freelance database developer/consultant.

     

    Hugo has over 18 years of SQL Server experience in various roles. He has a strong database design background, but also loves to write and tune complex queries.

    http://sqlblog.com/blogs/hugo_kornelis/default.aspx
  • Video