YoVDO

Improving Analytics Performance With Columnstore Indexes

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Database Administration Courses Columnstore Indexes Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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 Professional
PASS 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