When & Where to use Columnstore Indexes
DBA, Architect, BI/Analytics Practitioner
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