Subj.
Look at the deadlock graph and the statement below. Why does it happen?
declare @SomeValue bigint = 12345
select <SOME FIELDS>
from [HealthEvent].[StateMachineInstanceEventTypeQueue] nolock
where SomeField = @SomeValue
order by id desc
The table doesn't have an index on SomeField
See the deadlock graph: http://i58.tinypic.com/rbfmex.jpg