Tuning Problem Queries in Table Partitioning

Rated 4.86 out of 5 based on 7 customer ratings
(7 customer reviews)

$69.00 for 2 years

Speed up regressed queries after you implement table partitioning.

Out of stock

Description

Table partitioning is a fantastic tool to help you manage tables with skyrocketing rowcounts. SQL Server 2016 SP1 made table partitioning available in Standard Edition, so you may be planning to add partitioning to your database.

But some queries may get slower after you partition your tables: the SQL Server optimizer doesn’t always use indexes the same way after those indexes are partitioned into chunks.

This course teaches you to use execution plans to troubleshoot regressed queries using partitioned tables. You will learn what “non-aligned” indexes are, how to tell how many partitions a query is really using, and see options for TSQL and indexing changes to speed up your queries.

Course modules:

  • Course goals and demo data (6 minutes)
  • Problem Query: The Aggregator (34 minutes)
  • Problem Query: Max / Min (24 minutes)
  • Problem Query: Unexpectedly Blocked (9 minutes)
  • Interview questions and answers (10 minutes)
  • Pull it all together (4 minutes)

Each lesson is 16 minutes or less, so you can easily fit in a lesson today and pick up where you left off tomorrow.

Not ready to commit? Check out the course outline and preview three videos in the course.

7 reviews for Tuning Problem Queries in Table Partitioning

  1. Rated 5 out of 5

    Alessandro (verified owner)

    This is a very interesting course; it gives useful suggestions and shows techniques about the tuning with partitioned tables, with or without columnstore indexes.

  2. Rated 5 out of 5

    Jeff (verified owner)

    Great course! Although we do not do table partitioning here at work it was a nice exercise to get in and get your hands dirty with that technology. I like the course structure as I was able to do a quick session during my break and then not feel like I had to go back and figure out what I had to re-remember to start back up.

    If you are working with partitioned tables this is a must-have course for getting out in front of some of the potential pitfalls that come with partitioning.

  3. Rated 4 out of 5

    Tony (verified owner)

    Overall a good course on partitioning and problems which can arise.
    I would like the video playback speed to be adjustable so I can speed up or slow down at my pace.
    All hyperlinks to external (non-course) content should open a new tab instead of using the same course tab in the browser.

  4. Rated 5 out of 5

    Vladimir (verified owner)

    Enjoyed the course. It’s a bit on the advanced side, but that’s what makes it so much more interesting! There were a couple of times where I had to listen 2-3 times to understand the concepts, but if you really listen to what Kendra is saying it becomes clear.

  5. Rated 5 out of 5

    nkhalilbayli (verified owner)

    Excellent course. Highly recommended for every DBA who wants to get familiar with partitioning.

  6. Rated 5 out of 5

    Ian Turner (verified owner)

    Great course. Loving the interview questions.

  7. Rated 5 out of 5

    Heather Sullivan (verified owner)

    A great course covering some of the configuration & performance tuning considerations when using partitioned tables.

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…