mister.magoo (6/15/2014)
It's not very fancy, but I have found a query where NOLOCK really is desirable...SELECT result FROM fifaworldcup2014 [highlight="#ffff11"]WITH(NOLOCK)[/highlight] WHERE team='ENGLAND'
Here's hoping for that "incorrect data" we are constantly warned about 😛
Tried the code but something is wrong, constantly got the same error message
😎
'Transaction (Process ID 2014) was lost on resources with another process
and has been chosen as the tournament victim. Rerun tournament.'