Discover the power of columnstore compression to enhance analytic query performance in this 20-minute talk by Edward Pollack at SQLBits. Explore the secrets behind columnstore index compression and learn how to leverage this technology to optimize your database engine for modern analytics. Gain insights into SQL 2019 and SQL 2022 features, as well as platform-agnostic techniques for improving query performance. Delve into architecture and infrastructure considerations for big data and data engineering projects. Unlock the potential of columnstore indexes to revolutionize your data analytics capabilities and streamline your database operations.
Overview
Syllabus
Columnstore Index Compression in a Nutshell
Taught by
SQLBits