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.