Thanks for all the feedback on this one everyone. Good to hear.

Much less enjoyable are the people who have decided that because I’m an expert, whatever that means, that I have to have all the answers, all the...

And, of course, you're 100% correct on what you showed with the compatibility levels.

No, sorry for the confusion. My fault.

I meant take a backup from your 2019 instance and restore it to 2016.

Apologies for stating that poorly.

I know you are but what am I?

Sorry, couldn't help it.

A picture of a plan isn't a plan, all the good stuff is in the properties.

However, assuming that estimated plan is correct, and you're getting a clean index seek, then...

And, you can never restore it back down to 2016 ever again. Just something to be aware of.

I'm not sure I'd say that this is going to help performance, not because I'm against normalization, I'm very much in favor, but because I'm unsure of the root cause...

And, to determine what value to set your Threshold to, I'd take this approach or something like it.

However, that's for parallelism, which is much more often seen a choke...

Given this situation, yes, statistics maintenance should be the top of your list. Also, adjustments to the default settings of SQL Server. They're not always great. Cost Threshold for Parallelism...

So, please, I hope, you're testing this in a non-production environment, because, here's a bit of fun trivia, once you mark a database as in-memory, you can never undo that,...

Much less enjoyable are the people who have decided that because I’m an expert, whatever that means, that I have to have all the answers, all the time.

This sounds...

Thanks for your response .

I tried your query yesterday ( 19/02/2020 ) and use this command : WHERE last_execution_time >= '2020-02-15'

The result that I got is the records starting...

Ah, the big data clusters. Those are wicked cool. Also, they're not Availability Group technology. Well, I'm sure some is utilized. However, it's not a traditional AG. Instead, that's a...

Agent.