Columnstore Index Internals

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.
Presented by Sebastian Meine at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Sebastian_Meine.png

    Sebastian is the SQL Stylist at sqlity.net llc (http://sqlity.net). After receiving his PhD in Computer Science at the University of Linz, Austria he spent several years at a global Fortune 50 company as software architect responsible for code quality and performance of dozens of large-scale database installations throughout the US.

    In 2010, to fully engage in his passion for SQL Server, he founded sqlity.net. Since that time, he has been helping his clients to boost their SQL Server health and performance, enhance their T-SQL coding skills and tighten their SQL Server security.

    A sought-after educator and published author, Sebastian shares his knowledge regularly within the worldwide SQL community through his writings and public speaking engagements. Additionally he is coauthor of tSQLt, the Database Unit Testing Framework for SQL Server. tSQLt is open source and available at http://tSQLt.org.

    Sebastian is currently serving as president of the Philadelphia SQL Server User Group (http://pssug.org/), a nonprofit that is dedicated to further the education of the local SQL Server community.

    http://sqlity.net
  • Video
    The video is not available to view online.