tubeshowcase●1,668,814 videos♡ My collection 0
← Learn to Code

Learn to Code15:39

Making the Most of Clustered Columnstore Indexes in SQL Server 2022 & Azure SQL | Data Exposed: MVPs

Microsoft Developer ↗

From the creator

Columnstore indexes allow for storage of immense amounts of data, conveniently in SQL Server. This feature has evolved in every version of SQL Server since its inception. This is a speedy discussion of those improvements and how they can be leveraged to maximize storage and query efficiency for analytic data in SQL Server. Learn more in this episode of Data Exposed: MVP Edition with Anna Hoffman and Edward Pollack. 00:25 - Introductions 01:36 - What are Clustered Columnstore Indexes? 03:18 - How does it work? 04:01 - Demo of the compression 06:12 - Key things to know about implementing Clustered Columnstore Indexes 08:15 - Why use Clustered Columnstore Indexes over a standard Index? 09:31 - Other details to know about using Clustered Columnstore Indexes 14:00 - The importance of data order 15:01 - Closing ✔️ Resources: Microsoft Learn intro to columnstore indexes: https://learn.microsoft.com/sql/relational-databases/indexes/columnstore-indexes-overview Columnstore index series (by Ed): Architecture: https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/hands-on-with-columnstore-indexes-part-1-architecture/ Vertipaq optimization: https://www.red-gate.com/simple-talk/databases/sql-server/bi-sql-server/vertipaq-optimization-and-its-impact-on-columnstore-compression/ CCI in SQL Server 2022: https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/ordered-columnstore-indexes-in-sql-server-2022/ About Edward Pol

Published 2023-07-25 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.

Keep exploring Learn to Code