Session Details

View all Conference Sessions

When & Where to Use Columnstore Indexes

Niko Neugebauer
75 minutes
Data Management
DBA, Architect, BI/Analytics Practitioner
Database Administration
Columnstore Indexes have already taken over the world of BI & DWH, but deciding when and where to apply them can become a little bit tricky. In this session we shall be choosing the right platform for BI / DataWarehousing scenarios (SQL Server, Azure SQL DB, Azure SQL DB Hyperscale, Azure SQL DB Managed Instance or Synapse Analytics) and consider their advantages and limitations. Further, we shall dive into Query Processor advantages and limitations when processing Columnstore Workloads.
Knowledge of the Columnstore Indexes internals, Knowledge of the Performance Tuning, knowledge of Microsoft Azure Offerings