Indexing for Window Functions

Rated 5.00 out of 5 based on 1 customer rating
(1 customer review)

$49.00 for 2 years

Learn index design for windowing functions, when batch mode may be important, and compare the performance of Window Spool and Window Aggregate operators.

Out of stock

Description

Windowing functions give you great flexibility for analyzing data in SQL Server. But how can you get the best performance for your windowing functions?

In this 45 minute, demo-packed course, you will learn index design for windowing functions, when batch mode may be important, and how to compare the performance of Window Spool and Window Aggregate operators.

Course lessons:

  • Meet the challenge code (9 minutes)
  • Scripts and slide downloads
  • Dig into the plan and test a nonclustered index (11 minutes)
  • What can an indexed view do? (5 minutes)
  • Bring in the nonclustered columnstore index! (8 minutes)
  • Hacking in the Window Aggregate operator with a rowstore nonclustered index (9 minutes)
  • Summary and recap (4 minutes)
  • Quiz: check in on what you learned
  • Course survey

1 review for Indexing for Window Functions

  1. Rated 5 out of 5

    André Cardoso (verified owner)

    Great course by an amazing teacher/speaker.
    I think that this format and length was great (less than 12 lessons/videos with captions) and a final quiz to test the knowledge (for me it works best to watch the videos on my pace and if necessary watch some modules again where my knowledge lacks).
    The examples help to make the concepts more aproachable and focused on a single real problem.

Add a review

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

You may also like…