Concurrecny in Sqlservergreenspun.com : LUSENET : DBAzine : One Thread
We have Application Used by many users.
We have currently migrated from oracle to sqlserver
In Sqlserver we face Deadlocks Problems for eg:
user 1 Insert into table t values Select * from t
user 2 Insert into table t values Select * from t
When both the Users execute at the Same time we get Dead locks .Although nolocks can be solution for this we need reliable data , so we cannot opt for NOLOCK.
Is there any solution for this type of issues
-- Lakshmi Srikar (email@example.com), August 25, 2002