Команда разработчиков SQL Server создала целый ряд ресурсов, которые посвящены columnstore index и описывают различные сценарии работы с ним. Данный пост является подборкой ссылок на эти ресурсы.

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 is now supported on Standard and Express Editions

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: short-video why do we need it and 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 delay
• Minimizing impact of columnstore index maintenance using compression delay – performance numbers
• Real time operational analytics with memory-optimized tables
• Difference between CCI/NCCI
• Minimizing index fragmentation in columnstore index
• Columnstore index and the merge policy

Автор оригинала — Sunil Agarwal, обещал обновлять этот список.

От себя добавлю еще один замечательный ресурс, (структурировано) автором которого является Niko Neugebauer.