Please remove warning for WITH (NOLOCK)
When writing a report query using WITH (NOLOCK) a warning is produced saying "TABLE HINT is used"
It would be great to be able to configure that warning and turn it off.
Ben Anstey
shared this idea
Thank you for your suggestion.
We’ve reviewed this as part of our UserVoice triage.
If you’d like, you can turn off the table hint code analysis rule in the rule manager, but currently, we have no plans to allow the configuration of specific rules.
Using WITH (NOLOCK) is no longer recommended. Instead of doing NOLOCK in each query it’s better to use “Read commited snapshot” syntax. It provides you with consistent data, which while not always up-to-date means you avoid issues like duplication of data or missing data (non deterministic dirty reads). Please see the link below for more information.
https://sqlperformance.com/2014/05/t-sql-queries/read-committed-snapshot-isolation
Kind Regards,
The Prompt Team
-
Rob
commented
There are cases where we need nolock.
I have procedures where we need nolock on some tables but others should be locked during the query -
Anonymous
commented
Found any solution, please share !