How the 'no_lock' flag helps to avoid to deadlocks in MS SQL instance.
All recent versions of sqlserver probe.
The no_lock key applies to all queries sent to database via this connection. If this is not required, create custom checkpoint and add 'SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED' statement before the query or use NOLOCK hint in the query used in custom checkpoint.
If you want to set different transaction isolation level other than the default 'READ COMMITTED' and if you are aware of the consequence, you can set stricter transaction isolation level in custom checkpoint.