Deadlock issue in SQL Server -
i have 2 teams working in project, 1 extracting data table customer & products , other team trying view data tables. both of them performing operation simultaneously. causing deadlock. how solve issue?
use read committed snapshot isolation if using sql server 2005 , above. way readers not block writers.
Comments
Post a Comment