Inside the Columnstore Index
You have seen the marketing speak. You may have seen the demos. And maybe you have even played with the feature - columnstore indexes, the amazing "go faster" switch in SQL Server 2012!
But do you know how they work? Come to this session to find out. SQL Server MVP Hugo Kornelis will lift the hood to give you an in-depth view of all the internals, both documented and undocumented. How are columnstore indexes built and read? What is batch-mode execution? How does it operates, and how do these features work together to achieve an amazing performance boost?
If you just want to use the feature and profit from the much faster performance, you should find another sessions. But if you are a geek who wants to know all the nitty gritty details of this exciting new feature, then this is the session for you!
Sorry, there are no downloads available for this session.
Hugo is co-founder and R&D lead of perFact BV, a Dutch company that strives to improve analysis methods and to develop computer-aided tools that will generate completely functional applications from the analysis deliverable. The chosen platform for this development is SQL Server.
In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. For his contributions to the SQL Server community, Microsoft has given him the MVP award in 2006, and every year since.
The video is not available to view online.