Improving Analytics Performance With Columnstore Indexes
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
Explore the power of columnstore indexes for improving analytics performance in SQL Server in this comprehensive conference talk from PASS Data Community Summit. Dive into the architecture and benefits of columnstore indexes for storing and querying large-scale OLAP data. Learn how compression techniques and column metadata enable faster reads and efficient query processing over billions of rows. Discover the evolution of columnstore indexes from SQL Server 2012 to 2019, including new features that can significantly boost analytics workloads. Gain insights into best practices for data ordering, archive compression, and index maintenance. Examine write operations, segment elimination, and the delta store concept. Investigate nonclustered columnstore indexes and in-memory implementations to optimize your data storage and analytics capabilities.
Syllabus
Intro
Session Evaluation
OLAP Data Storage
What is a Columnstore Index?
Columnstore Index Architecture
Segment Elimination
The Delta Store
Write Operations: INSERT
Write Operations: DELETE
Best Practice: Data Order
Columnstore Archive Compression
Columnstore Index Maintenance
Nonclustered Columnstore Index
Columnstore Indexes...in memory?
Taught by
PASS Data Community Summit
Related Courses
Doing More with Less - The Challenges Ahead for Every Data ProfessionalPASS Data Community Summit via YouTube Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube Transform Your Data Estate
PASS Data Community Summit via YouTube Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube