Completed
Sunil Agarwal
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Columnstore Technical Deep Dive
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 Technical Assistance
- 3 Sunil Agarwal
- 4 Trends in the Data Warehousing Space
- 5 SQL Server 2014: In-memory Technologies
- 6 ColumnStore Index: How is it different ?
- 7 Columnstore Index: Terminology
- 8 ColumnStore Index: Example
- 9 Horizontally Partition (create Row Groups)
- 10 Vertically Partition (create Segments)
- 11 Compress Each Segment
- 12 ColumnStore - Index Types
- 13 Column Store - Creation and Compression
- 14 SQL Sever 2014: Clustered Columnstore Index (CCI)
- 15 Columnstore Index: TSQL Commands
- 16 Query Processing - Read The Data Needed
- 17 Query Processing: Segment Elimination Can significantly reduce the number of rows to be processed
- 18 Clustered Columnstore Index: Query Performance
- 19 Multi-Row Batch - Batch Mode Processing
- 20 Columnstore Index: Improved Batch Mode
- 21 Clustered Columnstore Performance: TPC-H
- 22 Clustered Columnstore Index: Updatable