Joe Obbish – Clustered Columnstore For Performance

This is a precon for SQL Saturday NYC, on October 5th.

The precon takes place the Friday before, on October, 4th.

Details:

Clustered columnstore indexes can be a great solution for data warehouse workloads, but there's not a lot of advanced training or detailed documentation out there. It's easy to feel all alone when you want a second opinion or run into a problem with query performance or data loading that you don't know how to solve.

In this full day session, I'll teach you the most important things I know about clustered columnstore indexes. Specifically, I'll teach you how to make the right choices with your schema, data loads, query tuning, and columnstore maintenance. All of these lessons have been learned the hard way with 4 TB of production data on large, 96+ core servers. Material is applicable from SQL Server 2016 through 2019.

Here's what I'll be talking about:

- How columnstore compression works and tips for picking the right data types

- Loading columnstore data quickly, especially on large servers

- Improving query performance on columnstore tables

- Maintaining your columnstore tables

This is an advanced level session. To get the most out of the material, attendees should have some practical experience with columnstore and query tuning, and a solid understanding of internals such as wait stats analysis. You don't need to bring a laptop to follow along.