SQL Server requests shared lock on a page in a statement with nolock hint

49 Views Asked by At

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

0

There are 0 best solutions below