04:07Making the Most of Clustered Columnstore Indexes in SQL Server 2022 & Azure SQL | Data Exposed: MVPs
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
04:07
11:04"Anti-Slop" Designs with Impeccable (a Crash Course) #5 - Enable Image Generation
Net Ninja
2:25:40
42:55Java Graphics Programming Tutorial - How To Draw Shapes, Paths, Curves, and Apply Transformations
choobtorials
08:10
18:31
7:09:47