SQL Server 2017 Showplan Schema Is Available

File this under…

Things probably only I care about. But the Showplan Schema for SQL Server 2017 popped up… well, I caught it last night. I probably could have written this sooner, huh?

So what’s new? Well, if I compare the 2016 SP1 schema using KDiff, a few things stand out. Some I’ve blogged about, and some… I have no idea what they are.

The first thing that shows up is the statistics used by the query. Both sp_BlitzCache and sp_BlitzQueryStore support this.

Stat Stud

After that is support for Interleaved Execution and Adaptive Joins. Unfortunately, from what I’ve been able to see, the Interleaved stuff is in actual plans only. Adaptive Joins are flagged in both cache-spelunking procs, but there’s not much analysis yet. Still gotta see if there are patterns to look for.

California Sun

There are a few odds and ends line that build plumbing in for AJ/IE, and then there’s this! Jackpot!

Anyone want a HJ?

So here’s the weird one.

ICKEY

I have no idea what these are for. If anyone from Microsoft wants to drop me a line, I promise I’ll… tell or not tell people about it. Whatever works for you.

After that, there’s this curious bit.

50 Shades of Optional

The reason this is curious is because TOP WITH TIES syntax has been around forever. I wonder what this is around for.

Nothing else was all that different or interesting. Which I guess means I can leave the plan cache procs alone.

Just kidding!

Thanks for reading!

Previous Post
How to Hire a Junior DBA
Next Post
Adaptive Blog Posts

2 Comments. Leave new

  • Mikael Eriksson
    September 29, 2017 3:33 am

    Just a guess but it could be that Top N Sort operator now supports queries using `with ties`. If you add `with ties` to a query that have the Top N Sort you will instead get one Sort and one Top operator (SQL Server 2016).

    Reply

Leave a Reply

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

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}