0.1 Prerequisites Before the Class (~4 hours)
Hi, Brent here! I’m really excited to welcome you to Fundamentals of Columnstore Indexes.
Read this whole page: there’s a lot of stuff in here for you.
Watch How to Think Like the Engine and Fundamentals of Index Tuning.
Before we get started, I need to make sure that we’ve covered the basics:
- How to Think Like the Engine – free 90-minute class that covers the foundations of clustered and nonclustered indexes, statistics, memory grants, and sargability.
- Fundamentals of Index Tuning – one-day class that covers how to index for WHERE, ORDER BY, and JOINs, and covers how to pick the field order for indexes.
- If you’re wondering why we only focus on SQL Server 2016 & newer in this class, and your production servers are on 2014 or older, read the documentation on what’s new in columnstore indexes, by version.
Armed with the material in those two classes, you’ll be well-equipped to keep up in the Mastering class.
Now, get your computer ready for the webcast.
To ask questions and talk to the other attendees, go to https://www.brentozar.com/slack/ to get an instant invite, then join the #BrentOzarUnlimited channel. This way attendees can help each other with their questions during the live labs. (We don’t use the GoToWebinar Q&A or chat because you can’t see each other’s chats.)
Want to run the demos on your own machine?
If you didn’t buy a lab VM, or if you want to run the demos after the class finishes, read the scripts and databases setup.
- 0.2 How to Set Up Your Own Lab Server
- 01 How Columnstore Data is Stored
- 02 How Columnstore Data is Deleted, Updated, and Inserted
- 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 Bigger, Better Clustered Columnstore Candidate
- 08 Partitioning Is a Great Partner for Columnstore
- 09 Recap