In this session we are going to take a deep dive into the columnstore index feature introduced in SQL Server 2012. We will compare columnstore with b-tree indexes and see why a columnstore index is not really an index at all.
After attending you will be able to identify queries that will benefit from columnar storage. You will be able to explain how the data in a columnstore index is stored on disk and which access mechanisms are available to SQL Server. You will be able to see whether a query is running in row mode or is utilizing the new batch mode and explain the difference between the two.
In this talk we will also cover the gaps that were left in the current implementation, scheduled to be filled in a future version of SQL Server.