We started this class with a freshly built columnstore index stored in a grid of row groups and column segments. Next, let’s start changing the data by running deletes, updates, and inserts to see the new objects getting created. We’ll see how insert volume affects whether new rows go into the delta store or new…
02 How Columnstore Data is Deleted, Updated, and Inserted
We started this class with a freshly built columnstore index stored in a grid of row groups and column segments. Next, let’s start changing the data by running deletes, updates, and inserts to see the new objects getting created. We’ll see how insert volume affects whether new rows go into the delta store or new…
To access this incredible, amazing content, you gotta get Recorded Class Season Pass or Fundamentals of Columnstore Indexes, or log in if you already shelled out the cash.
- 0.1 Prerequisites Before the Class
- 0.2 How to Set Up Your Own Lab Server
- 01 How Columnstore Data is Stored
- 03 How Columnstore Data Is Selected
- 04 How Columnstore Data is Rebuilt
- 05 Clustered Columnstore Quiz: Is Your Table a Good Fit?
- 06 Nonclustered Columnstore Advantages
- 07 A Better Clustered Columnstore Candidate
- 08 Partitioning Is a Great Partner for Columnstore
- 09 Recap