Columnstore Index - selection from SQL Server Product Team

The SQL Server team has created a number of resources that are dedicated to the columnstore index and describe various scenarios for working with it. This post is a compilation of links to these resources.

Columnstore index

• Short video on columnstore
• Channel 9 - columnstore technology
• Why columnstore Index
• How does columnstore speeds up analytics
• What is new in SQL Server 2016
• Columnstore index and transaction isolation levels
• concurrency and Insert Operation
• Scan and Parallelism
• Columnstore index and rowgroup sizes
• Enforcing uniqueness constraint in clustered columnstore index
• Difference between columnstore index vs Btree Index
• Which columnstore index is right for me?
• Loading data from staging table
• Columnstore success stories
• Columnstore index in lower editions
• Why do we call it In-Memory analytics
• Should I partition my columnstore
• Columnstore and Stats
• Columnstore Index
')
Columnstore Index Presentations at conferences

• Clustered Columnstore Index
• Updateable NCCI Real Time Operational Analytics in SQL Server 2016
• Columnstore success stories

Columnstore index performance

• Columnstore index value proposition
• Column elimination
• Rowgroup elimination
• Batch mode execution
• Aggregate pushdown
• String predicate pushdown
• Multiple aggregates
• Batch mode Windows aggregates
• No more Performance Cliff

Bulk importing data

• Basic Bulk Import Operations
• Parallel Bulk Import
• Bulk Import with Minimal Logging
• SSIS and Columnstore

JSON in Columnstore Index

• JSON support with columnstore index
• Extreme 25x compression of JSON data using CLUSTERED COLUMNSTORE INDEXES

Real Time Operational Analytics (HTAP)

• Real-time operational analytics: high-level overview
• Business case for real-time operational analytics
• Using nonclustered columnstore index for real-time operational analytics
• A simple example using NCCI
• How does SQL Server maintains NCCI with transactional workload
• Minimizing impact of columnstore index maintenance using filtered index
• Minimizing impact of columnstore index maintenance using compression
• Minimizing impact of index columns
• Real time operational analytics with memory-optimized tables
• Difference between CCI / NCCI
• Minimizing index fragmentation in columnstore index
• Columnstore index and the merge policy

The original author, Sunil Agarwal, promised to update this list.

From myself I will add one more remarkable resource , ( structured ) the author of which is Niko Neugebauer .