GroupBy: New Engine Features in SQL Server 2019

Aaron Bertrand

Published On: December 21, 2018

Categories: SQL Server 2019, SQL Server on Linux 1

This morning I presented a session on SQL Server 2019 (video here, deck and samples here), and the demo gods were very unkind to me. They spoiled not one demo, but two!

The first demo that bombed was ADD SENSITIVTY CLASSIFICATION. I guess I created too many audits preparing for the session and got a wire crossed somewhere.

The second demo that bombed was create resumable index - some timing issue I couldn't nail down between the start of the operation and the pause. This is what was supposed to happen:

  1. Start a lengthy index operation
  2. Jump to a separate tab and pause it
  3. Observe that the index creation was, in fact, interrupted
  4. See how far it got, then resume and let it finish

I've confirmed that running the scripts now, not under duress, they work as expected.

Download the deck and samples (~23MB)

After two demo fails, Kendra suggested I don't cross any streets. How right she was. On the way to the dentist at lunchtime, I picked up a $1,300 deck screw:

Tire

I have run-flats, so I was able to drive to the shop. But since I have all-wheel drive and (I'm learning now) a very sensitive DSC system, all four tires have to be replaced so they have nearly identical tread war. So that was fun!

Aaron (@AaronBertrand) is a Data Platform MVP with industry experience dating back to Classic ASP and SQL Server 6.5. He is editor-in-chief of the performance-related blog, SQLPerformance.com, and serves as a community moderator for the Database Administrators Stack Exchange. Aaron's blog focuses on T-SQL bad habits and best practices, as well as coverage of updates and new features in Plan Explorer, SentryOne, and SQL Server.


Comments

Sentryone Monitoring Platform Trial