HanShi (7/17/2013)
Could you rewrite the delete statement to:
DELETE TOP (20) FROM [dbo].[ServerParametersInstance]
WHERE Expiration < @now
This will prevent the query to simultaneously read and delete from the same table.
Hi,
This has resolved the deadlock, thank you both for your help with this.
Nic