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

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