When i started my programmer life yearss ago, i was always been told to that use nolock on select statement. Until a week earlier, my superior make me really have a thought on it.
He only threw me a sentence “Everyone wants to use nolock but there are some serious side effects to consider so as a rule only use when there is no other alternative“, very interesting indeed.
I see people discussing about nolock here, this discussion inspired me -I always keep thinking if the data is locked by a transaction and nolock can improve the performance, but i miss out (nolock) is actually performing dirty read!
#Learn from mistakes#