Just tried it with and without (nolock) option - doesn't make any difference. The problem in my eyes that SQL Server is trying to join #temp table with one...

As I mentioned we did run statistics and it didn't help. The other difference is that data center machine is clustered (3 physical machines with 3 sql server instances)....

We run it so many times, 2 people. I wish I would make a mistake 🙁 Just run out of options.

I tried yesterday to run a...

Thank you very much for your suggestions.

Please see attached the new execution plan after parallelism was turned on.

The dataset is absolutely the same, the number of processors -...