Hi,

Using the LOCK hint to SELECT query it is a very good issue. I have tested it in my production environment and it is very useful. Before that it was a lot of lock waits and deadlocks. There is an ERP application which is running here and the isolation level of transactions was set in the code of this application. So, I have used this hint.

I want to point the author of this article to make tests of this hint on concurrential systems. There is a huge difference between using and not using LOCK hint.