Improving Columnstore Load Scalability on Large Servers - Joe Obbish

Clustered columnstore indexes can be a great solution for data warehouse workloads, but loading lots of data as quickly as possible is still a cutting edge problem. Experience a tour de force of columnstore scalability with total load time starting at 260 minutes and dropping to just 6 minutes. The techniques to achieve such an improvement are derived from lessons learned from production workloads with billions of rows. Session material is applicable to SQL Server 2016, 2017, and 2019. Get ahead of the pack and improve your columnstore load times, increase scalability on your large servers, or simply be challenged. Attendees must have a good understanding of columnstore, wait stat analysis, extended events, and latches to get full value out of this session.
Watch the session recording from PASS Summit 2019. For updates on the future of PASS, SQLSaturdays and PASS Summit opt in here: www.red-gate.co...