Home » Blog » Presentation Materials – Columnstore Index Internals

Presentation Materials – Columnstore Index Internals

2012-08-08 - Presentations

Abstract

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.

Downloads

• Slides

Other Resources

• Columnar Storage in SQL Server 2012 (2012, IEEE - Per-Ake Larson, Eric N. Hanson, Susan L. Price)
• Column-Stores vs. Row-Stores: How different are they really? (2008, SIGMOD - Daniel L. Abadi, Samuel R. Madden, Nabil Hachem)
• SQL Server Columnstore Index FAQ (microsoft.com)
• SQL Server Columnstore Performance Tuning (microsoft.com)
• The coming in-memory database tipping point (2012, blogs.technet.com - David Campbell)
• Perform Scalar Aggregates and still get the Benefit of Batch Processing (microsoft.com)
• Work Around Performance Issues for Columnstores Related to Strings (microsoft.com)
• Ensuring Your Data is Sorted or Nearly Sorted by Date to Benefit from Date Range Elimination (microsoft.com)
• Columnstore Indexes (msdn.microsoft.com)
• Inside the SQL Server 2012 Columnstore Index (2012, rusanu.com - Rusanu Consulting llc)
• Multi-Dimensional Clustering to Maximize the Benefit of Segment Elimination (microsoft.com)

Categories: Presentations