Hi We have a sql 2008 Enterprise Edition x64 on a win 2008 cluster. The application is a 3rd party app that normally uses Oracle or DB2. We have been having deadlock issues in our environment. The vendor mentioned they don't have deadlocks in Oracle or DB2
and said they use DB2_EVALUNCOMMITTED (From DB2 manual, "which improve concurrency of scans, it may be possible to defer row locking until after determining that a row qualifies for a query) to improve concurrency, is there a similar feature in SQL Server?
View Complete Post