GilaMonster (10/30/2013)
tony28 (10/30/2013)
Like I said, I didnt see yet problem with no lock ...Doesn't mean it didn't happen. If you have locking problems, consider one of the snapshot isolation levels. Readers don't block writers and you don't have the intermittent incorrect results problem.
yes without dirty reads, I have to read few block for refresh about this things ,, thx