Columnstore indexes provide an excellent solution to storing large analytic data in SQL Server. They can tame tables with millions or billions of rows with ease.

Understanding their architecture, compression, and best practices can allow for significantly faster workloads while saving computing resources.

This session dives into the details of how columnstore indexes work. Topics discussed will include:
Columnstore encoding, optimization, and compression algorithms
Segment and rowgroup elimination
Optimization of secondary indexes
Best practices for data load processes

This is an advanced dive into columnstore indexes that will allow anyone interested in this technology to make the most of its features in SQL Server 2019+