Columnstore Technical Deep Dive

Columnstore Technical Deep Dive

PASS Data Community Summit via YouTube Direct link

Sunil Agarwal

3 of 22

3 of 22

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. 1 Intro
  2. 2 Technical Assistance
  3. 3 Sunil Agarwal
  4. 4 Trends in the Data Warehousing Space
  5. 5 SQL Server 2014: In-memory Technologies
  6. 6 ColumnStore Index: How is it different ?
  7. 7 Columnstore Index: Terminology
  8. 8 ColumnStore Index: Example
  9. 9 Horizontally Partition (create Row Groups)
  10. 10 Vertically Partition (create Segments)
  11. 11 Compress Each Segment
  12. 12 ColumnStore - Index Types
  13. 13 Column Store - Creation and Compression
  14. 14 SQL Sever 2014: Clustered Columnstore Index (CCI)
  15. 15 Columnstore Index: TSQL Commands
  16. 16 Query Processing - Read The Data Needed
  17. 17 Query Processing: Segment Elimination Can significantly reduce the number of rows to be processed
  18. 18 Clustered Columnstore Index: Query Performance
  19. 19 Multi-Row Batch - Batch Mode Processing
  20. 20 Columnstore Index: Improved Batch Mode
  21. 21 Clustered Columnstore Performance: TPC-H
  22. 22 Clustered Columnstore Index: Updatable

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.