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
Last activity: Jun 24, 2025, 07:39 AM