|
Posted by Greg D. Moore \(Strider\) on 04/13/06 06:20
"D0MZE" <domze.sa@gmail.com> wrote in message
news:1144891406.165135.214850@i40g2000cwc.googlegroups.com...
> Not sure if this could be relevant but perhaps add WITH(NOLOCK) on your
> queries.. With this, no locks would actually happen.
Not quite.
For a select it basically means to ignore locks on rows.
This can mean you can get phantom rows, not get rows you should etc. i.e.
you'll get an inconsistent view of the table at the time.
This MAY be acceptable in some circumstances, but in others would be
completely verbotin. (imagine an ATM that did a look up on cache available
with a (NOLOCK) while your bank is deleting your last check. You'd falsely
be told you have more money available than you actually do and could
overdraw the account.)
>
Navigation:
[Reply to this message]
|