Columnstore Index Compression in a Nutshell
Offered By: SQLBits via YouTube
Course Description
Overview
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.
Syllabus
Columnstore Index Compression in a Nutshell
Taught by
SQLBits
Related Courses
Implementing In-Memory SQL Database ObjectsMicrosoft via edX Developing SQL Databases
Microsoft via edX Implementing a Data Warehouse SQL Server 2019
LinkedIn Learning SQL Server Performance for Developers
LinkedIn Learning Optimizing Query Performance with Columnstore Indexes
Pluralsight