Home Forums SQL Server 2008 SQL Server 2008 - General unexplained lock escalation - please help! RE: unexplained lock escalation - please help!
Lynn Pettis
SSC Guru
Points: 442467
More actions
February 26, 2013 at 11:13 am
#1591273
One change to your code would be this in the CTE:
SELECT TOP (100) ID
FROM dbo.TableA
WHERE TableAStatusTypeID IN (1, 5, 9) AND LastUpdateTime <= dateadd(ss, -300, @CurUtcDate)
ORDER BY LastUpdateTime ASC