Got a little spooked when I found this in some production code. After reading around the subject I’m more comfortable with the theory and learned something new today!
This is a good resource for understanding this sort of thing and has highlighted that I need to dive deeper into optimisation techniques.
http://aboutsqlserver.com/lockingblocking/
Advertisements
