Execution Plans: Partitioned Tables & Columnstore Indexes

Rated 5.00 out of 5 based on 3 customer ratings
(3 customer reviews)

$69.00 for 2 years

Learn to interpret whether partition and rowgroup elimination are occurring in your SQL Server queries.

Out of stock

Description

Execution plans are incredibly helpful when it comes to tuning queries using partitioned indexes and columnstore indexes — but when you look closely, you’ll notice that some things are very weird! Learn how to see how many partitions have been accessed by a query, and when SQL Server will lie about the partition count. See when “0 rows” is really more than 0 rows, and learn the basics of batch mode vs row mode operators.

This course contains 90 minutes of videos, with a quiz and downloadable desktop wallpaper.

Course lessons include:

  • Partitioning and columnstore concepts (10 minutes)
  • Download scripts, slides, and wallpaper
  • Disk based rowstore: actual plans, cached plans, and Query Store (21 minutes)
  • Columnstore: 0 partitions accessed- but rowgroup elimination! (15 minutes)
  • More fun with rowgroup elimination and predicate pushdown (12 minutes)
  • When doing more is less work: comparing Query Time Stats for two queries (5 minutes)
  • When you can get batch mode operators, and an example of their power (14 minutes)
  • Batch mode hacks, and what does the future hold? (9 minutes)
  • QUIZ TIME!
  • Concepts to remember, and thank you! (4 minutes)

3 reviews for Execution Plans: Partitioned Tables & Columnstore Indexes

  1. Rated 5 out of 5

    Martin Surasky (verified owner)

    Kendra…

    I got into this 90 minute course with not much working knowledge of partition elimination or rowgroup elimination, also had not much of an idea of how to look at query plans using batch mode operators and partitioning. In other words, most of the concept in this course, even though it touches on things that I know vaguely what they are about, was new to me.

    I have to said that after only 90 minutes, I got to grasp each and every new tip introduced. Not only the material made it really easy to follow (I downloaded and played with the BabbyNames as I followed along) but the pace was perfect!

    Thanks not only for putting these contents together but also for making it available for free to the SQL Community (at least for now). I will certainly recommend this training to my colleagues!

  2. Rated 5 out of 5

    Mikhail Kolesnichenko (verified owner)

    It is a great course for those who are new (like me) to the notions of partitioning or columnstore indexes.
    Author gives really useful insights into what places to watch out and how to get maximum performance out of the mentioned features

    Thank You for this fun and insightful course

  3. Rated 5 out of 5

    joao.caxias (verified owner)

    Kendra,
    Thank you so much for your hard work , putting these lessons on and preparing the scripts. Sharing knowledge like you do is what drives evolution and innovation for SQL professionals.
    You also make it fun to learn. Keep up the amazing work.
    The shared links to other SQL masters are extremely valuable.

Add a review

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

You may also like…