I've noticed DELETE and UPDATE queries that are based upon a large SELECT statement such as NOT IN (SELECT ID FROM LARGE_TABLE) are often ending up with deadlocks. Is this causing deadlocks and if so ...
We currently have a trigger-based system in place that does the following: When records in certain tables are modified, a trigger fires that makes a field NULL in a varying number of records in ...
Can somebody explain me how a process can acquire SIX lock on a page? I my deadlock-graph xml file I see that a process running under RC isolation level (executing a select statement at the moment of ...
I have the following procedure (SQL Server 2008r2): create procedure usp_SaveCompanyUserData @companyId bigint, @userId bigint, @dataTable tt_CoUserdata readonly as begin set ...