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

Popular posts from this blog

Cursor error with postgresql, pgpool and php -

c# - how to write client side events functions for the combobox items -

ssh client with paramiko (python) -