Sample Header Ad - 728x90

Is NOLOCK always bad?

35 votes
4 answers
5039 views
I am a Report Developer who wants to make my queries as efficient as possible. I used to work with a DBA who told me - I believe because I was always dealing with reports on a Production Server - to use NOLOCK in every single query. Now, I work with a DBA who has banned NOLOCK under any circumstance - even when a report of mine (due to a considerable lack of indexes on a couple of tables) is stopping replication and system updates. In my opinion, in this case, a NOLOCK would be a good thing. Since most of my SQL training has come various DBAs with very different opinions, I wanted to ask this to a wide variety of DBAs.
Asked by DataGirl (475 rep)
Jan 13, 2012, 06:01 PM
Last activity: Jun 24, 2025, 07:39 AM