Dead Lock occurs if more than one process shares the same resource(Table). we can avoid it by using NOLOCK keyword after the table name. The Nolock should be used only for select statement and it should not be used for Update or delete statements.
What is a Dead lock in SQL ? was last modified: October 1st, 2017 by