Completed
Intro
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
