Columnstore Technical Deep Dive

Columnstore Technical Deep Dive

PASS Data Community Summit via YouTube Direct link

Clustered Columnstore Index: Updatable

22 of 22

22 of 22

Clustered Columnstore Index: Updatable

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.