As I have already mentioned the problem occurred the day I reindexed and updated the database statistics. I run second time update statistics and everything is ok. Thank you.

I read the answers and I am back to add another evidence. The problem occurred the day I reindexed and updated the database statistics. But I have been doing this...

• This reply was modified 4 years, 1 month ago by  nonlinearly.
• This reply was modified 4 years, 1 month ago by  nonlinearly.
• This reply was modified 4 years, 1 month ago by  nonlinearly.

I have not yet read the previous 2 answers but I want to catch you and add an important new fact. Ultimately the problem is not the computers but the...

Trace files are discarded and I attach them again as xml

• This reply was modified 4 years, 1 month ago by  nonlinearly.

It was the statistics. I issue the command EXEC sp_updatestats 'RESAMPLE'.

Thanks

I can't retrieve Actual Plan because the query never ending to show me the AP! But I have looked in the statistics of the tables that participate in the query...