SQL Server 2017: Unpublished Gems

Sneaky, sneaky, sneaky

Release notes never seem to tell the full story, do they?

At some point, you have to take matters into your own hands and go hunting for, as Paul Harvey would say, “The Rest Of The Story”.

So what did I find?

New stuff! Brand. New. Stuff. For you. If you ever upgrade, lazybones.

This the full list of new stuff.

FINGER WIGGLE

I’m not going to talk about all of them, just a few that I find interesting. Hint: you’re not going to learn anything about Linux.

sys.dm_db_missing_index_group_stats

sys.dm_db_missing_index_group_stats
What have we here?

SO MANY COLUMNS!

Swoon

Of particular interest are last_sql_handle, query_hash, and query_plan_hash. It appears that we’ll finally be able to easily tie missing index requests to their queries, without doing a lot of painful XML processing. I had planned on adding something like this, but couldn’t find a good fit between 1) adding XML processing to sp_BlitzIndex, or adding more DMV queries and rather unpleasant XML processing to sp_BlitzCache. This will make implementing it far easier, assuming it works the way it looks like it will work.

fn_full_dblog

Up next is a new function called fn_full_dblog. This apparently makes querying fn_dump_dblog easier, and hopefully more bug-free.

I wouldn’t want to remember all that, either.

dm_exec_query_stats

Has a bunch of new columns that tell you about ColumnStore index access. You know, if you’re into that sort of thing.

Hey sailor.

Bright and shiny

All this new stuff, and we’re only on CTP 2. I can’t wait to see what gets added between now and release day.

Thanks for reading!

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