22 March 2017

Columnstore Index – подборка от SQL Server Product Team

SQLMicrosoft SQL Server
Команда разработчиков 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.
Tags:sqlservermicrosoftsqldatabasesindexingcolumnstore indextsql
Hubs: SQL Microsoft SQL Server
+4
4.6k 24
Comments 3