Thanks for all the comments. I will definitely have to do more research and reading.

But let me also be a bit more specific

If the statements are executed sequentially from...

Sorry but your answer does not make sense. No lock is suppose to speed up your queries because the overhead of locking is not happening. Also because nolock is specified...