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

Video Description

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 Pollack: Ed Pollack is a Microsoft Data Platform MVP with a passion for learning how the Microsoft Data Platform works and sharing that knowledge with the community. His experiences in data architecture, database design, performance optimization, and data security are motivation for public speaking, writing, coding, and other community activities. Ed has spoken at SQL Saturday events, SQL Bits, PASS Summit, EightKB, and many other regional and international events. Ed is the organizer of the Capital Area SQL Server Group and SQL Saturday Albany, as well as a co-organizer of SQL Saturday New York City, and Future Data Driven. He has published a number of books, including "Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server", "Expert Performance Indexing in Azure SQL and SQL Server 2022", and "Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads". Ed is also an active contributor of content to SimpleTalk. About MVPs: Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram 📌 Let's connect: Twitter - Edward Pollack, https://twitter.com/edwardpollack Twitter - Anna Hoffman, https://twitter.com/AnalyticAnna Twitter - AzureSQL, https://aka.ms/azuresqltw 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQL #LearnSQL