I'm not sure this has to do with the issue at hand BUT, if you replace the parameter by its value directly, then the extra part of the exec plan...

Hi Mike,

maybe the data distribution in your table has something to do with it? From the look of the query, I would suggest the same index as the QO by...

• This reply was modified 3 years, 9 months ago by  Broniz.
• This reply was modified 3 years, 9 months ago by  Broniz.

Hi everyone, quick question for my understanding: Starting from SQL 2016, couldn't we use Availability Groups, even basic AG, to do the equivalent automatically?

Thank you !

• This reply was modified 3 years, 9 months ago by  Broniz.

Thank you for the guidance, that is helpful.

Thx, I'll get all the information from them before trying to do anything. Not even sure they have EE to be honest.

Thanks a lot Alan.

I wanted to try using SQL Snapshots for the BI and Excel, but I'll try using replication.

I'm in middle of using Diskspd to get actual...

+1