Clustered Columnstore index deep dive

Sign in to queue

Description

SQL Server 2016 adds key enhancements to improve the performance and flexibility of columnstore indexes. This enhances data warehousing scenarios and enables real-time operational analytics. The objective of this session is Rationale for using columnstore index for DW and at the same time showcase new enhancements to columnstore index in SQL AzureDB and SQL 2016.We will do a deep dive in columnstore index internals where we are going to talk about new Physical structure, Query Performance, Concurrency and High availability .

Day:

2

Level:

Level 300

Session Type:

Breakout

Code:

DA325

Room:

Room 7

Embed

Download

Download this episode

The Discussion

Add Your 2 Cents