Columnstore Technical Deep Dive

Dive deep into the world of columnstore technology in Microsoft SQL Server 2014 with this comprehensive technical session. Explore the revolutionary addition of updateable columnstore and its significant impact on query performance. Gain insights into columnstore internals, understand how it differs from row store, and learn about the metadata that exposes this new information. Discover trends in data warehousing, in-memory technologies, and the intricacies of columnstore index types, creation, and compression. Examine query processing techniques, including segment elimination and batch mode processing, and their effects on performance. Analyze the implementation of clustered columnstore index in SQL Server 2014, its TSQL commands, and its impressive performance in TPC-H benchmarks. Master the concepts of row groups, segments, and horizontal and vertical partitioning to optimize your database performance.

Intro
Technical Assistance
Sunil Agarwal
Trends in the Data Warehousing Space
SQL Server 2014: In-memory Technologies
ColumnStore Index: How is it different ?
Columnstore Index: Terminology
ColumnStore Index: Example
Horizontally Partition (create Row Groups)
Vertically Partition (create Segments)
Compress Each Segment
ColumnStore - Index Types
Column Store - Creation and Compression
SQL Sever 2014: Clustered Columnstore Index (CCI)
Columnstore Index: TSQL Commands
Query Processing - Read The Data Needed
Query Processing: Segment Elimination Can significantly reduce the number of rows to be processed
Clustered Columnstore Index: Query Performance
Multi-Row Batch - Batch Mode Processing
Columnstore Index: Improved Batch Mode
Clustered Columnstore Performance: TPC-H
Clustered Columnstore Index: Updatable