ColumnStore Index: Microsoft SQL Server 2014 and Beyond

Sign in to queue

Description

The updateable clustered columnstore in SQL Server 2014 offers a leading solution for your data warehouse workload with order of magnitude better data compression and query performance over traditional btree-based schemas. This session describes columnstore index internals with deep insight into data compression methodology for achieving high query performance. Additionally, we offer a sneak preview of column store investments planned for SQL Server.

Day:

3

Level:

400

Session Type:

Deep Dive

Code:

BRK4556

Room:

S401

Embed

Download

Download this episode

Download captions

The Discussion

Add Your 2 Cents