Ashok Kumar SQL Development and DBA Adminstrations Techi Blog
(SQL Materials for Every one to Share)
Counter of Festivals
Tuesday, 16 June 2015
To resolve Deadlock other than Nolock hints
Please do not use NOLOCKs blindly. NOLOCKS results in dirty reads which can become a problem for your application. NOLOCKS are suggested when the tables thay are used against are seldom changed. If your tables have frequent transactions on them, NOLOCKS are not recommended.
To help minimize deadlocks, you can use any of the below suggesstion-
Access objects in the same order.
Avoid user interaction in transactions.
Keep transactions short and in one batch.
Use a lower isolation level.
Use a row versioning-based isolation level. Set READ_COMMITTED_SNAPSHOT database option ON to enable read-committed transactions to use row versioning. OR. Use snapshot isolation.
Use bound connections.
Check this link for further details in achieveing this.