Avoid using NOLOCK on UPDATE and DELETE statements Tip : Avoid using NOLOCK on SQL Server UPDATE and DELETE statements