This 2/300 level, live, online training course will provide an understanding of the differences between rowstore and columnstore indexes and how to plan for, implement, and maintain columnstore indexes in SQL Server 2012 and higher using best practices and our extensive real-world experience.
The class will start off by providing a foundation of how data is stored in SQL Server using row storage and B-tree indexes compared with columnstore indexes, as a means of understanding why columnstore indexes are better suited for certain workloads. Then you’ll learn how to implement columnstore indexes and strategies for using them, including combining rowstore and columnstore in the same table. We’ll cover how to find information about columnstore indexes once they have been implemented, data loading patterns for different workloads and their impact on columnstore and potential problems to watch out for, and finally how to maintain columnstore indexes and design the schema leveraging partitioning for optimization of the indexes and performance of queries and data loading.
By the time you’ve been through this class, you’ll have the knowledge to choose when to use columnstore indexes and how to use them most effectively in your environment.
This class is delivered live via online streaming. By dedicating only 3 half-days of your time for 9 hours of lecture and up to 4.5 hours of open Q&A, this is an amazing ROI while you can still get work done during your day!
Instructor: Jonathan Kehayias.
For a detailed agenda click HERE.
If you need help justifying training to your organization, we can help you:
Click HERE to go to our events registration page, and please make sure to select the correct class from the drop-down menu at the top of the page.
If you have any questions, please contact us.