Shared lock and intent exclusive lock causing DeadlockHi all,
Currently I am working on deadlock issue which is causing because share lock(s) and intent exclusive lock().
As we know select query acquire share lock and update query acquire intent exclusive lock.
Both the statement select and update acquire page level lock and both are in wait state to get lock on each other.
Our DB architect suggested that use NOLOCK hint with select statement, but data we are fetching from table is so important it should be correct every time and with NOLOCK we cant sure the data accuracy because of dirty read.
Please let me know if is there any solution for this issue?