Advanced OLAP Optimization with Columnstore Indexes

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+

Edward Pollack

Data Architect | Microsoft Data Platform MVP

Albany, New York, United States


Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top