Hi,
Here you can find the explanation of the problem, answers and advices.
https://dba.stackexchange.com/questions/132410/long-running-select-query-fails-as-deadlock-victim-to-a-delete-on-sql-server-w
Here you can find the explanation of the problem, answers and advices.
https://dba.stackexchange.com/questions/132410/long-running-select-query-fails-as-deadlock-victim-to-a-delete-on-sql-server-w
Dominique.