Hey everybody, Geon here again with another exciting
instalment of “SQL Something”.
Today we are going to be looking at querying using NOLOCK.
When I first started working where I am, I used to run my SELECT
queries ‘normally’, that is, without using the NOLOCK feature. I remember one day I put a large query to
run (one that normally took about 30 minutes) with the mind-set that I’ll
“check back on it in a bit”. Ten minutes later one of our sys admins pointing
out that one of our applications started throwing a bunch of errors, all
database related. This app almost continuously wrote data to its database.
Suddenly, it could not insert anything into one of its database tables and was
kicking up a massive fuss because of it.
