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 query with an execution plan from the "good" one and it did work, but for some unknown reasons SQL Server is choosing the wrong plan when it runs query as it is, even i tried to put tables in a different order in the "from" clause. We checked settings for the sql server and it is the same. I checked auto-update statistic option and it is set to "true".