Best practice pinned on noticeboard

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#