Actions Panel
Joe Obbish – Clustered Columnstore For Performance
Action Man Joe Obbish brings an incredible amount of in-depth knowledge about clustered column store performance.
When and where
Date and time
Location
Courtyard by Marriott New York Manhattan/Times Square 114 West 40th Street Meeting Room A+B New York, NY 10018
Map and directions
How to get there
Refund Policy
About this event
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.