skavijay (9/8/2014)
But after knowing this disable option just want to know expert opinion whether that might helpful to me or not?
No idea at all, because you haven't given any information about the table, query or deadlock. Hence no one can give any useful, relevant information at all.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability