Hacking in the Window Aggregate operator with a rowstore nonclustered index (9 minutes)

Please purchase the course before starting the lesson.

Can we get SQL Server to give us our data nicely pre-sorted in a rowstore index, but use that fancy new batch mode Window Aggregate operator on it?

Back to: Indexing for Windowing Functions (45 minutes) > Let's Tune It