Tagged Questions
6
votes
1answer
147 views
LATCH_EX Waits on Resource METADATA_SEQUENCE_GENERATOR
We have a process that generates an inventory report. On the client side, the process splits of a configurable number of worker threads to build a chunk of data for the report that corresponds to one ...
2
votes
0answers
61 views
How to safely take an SQL job out of the schedule?
There is a table | jobID | status | startTime | endTime | and a job, that is scheduled to run every X seconds, it will take the first undone job ID, put it in stored proc and run it. Stored proc takes ...
2
votes
1answer
80 views
Isolation and atomiticy of SQL Server UPDATE
Is there any difference in atomicity and isolation between the two following SQL statements?
Batch A:
UPDATE Orders
SET InProgress = 1
WHERE Completed = 0
and
Batch B:
UPDATE Orders
SET ...
1
vote
1answer
414 views
Differences between SQL Server 2005 and SQL Server 2008 deadlock handling
We recently upgraded a server to SQL Server 2008 R2. The server had been running SQL Server 2005. We are using
Transactional Replication
Management Data Warehouse and Data Collector on the ...
2
votes
1answer
281 views
performance issues when concurrent requests
We are using SQL Server 2008 R2 on a Windows Server 2008 server.
We have some main functions which uses some Stored Procedures which has a lot of sub-queries inside of it.
I'll take one SP as an ...
7
votes
3answers
967 views
Insert if not exists, concurrently
I am having concurrency issues with my inserts in a stored procedure. The relevant part of the procedure is this:
select @_id = Id from table1 where othervalue = @_othervalue
IF( @_id IS NULL)
BEGIN
...
5
votes
4answers
388 views
Resources for understanding SQL Server locking and concurrency?
As demonstrated by a recent question of mine locking and concurrency are HARD.
Can you suggest any good resources for intermediate-to-advanced SQL professionals to do a thorough study on these that ...
13
votes
3answers
1k views
Managing concurrency when using SELECT-UPDATE pattern
Let's say you have the following code (please ignore that it's awful):
BEGIN TRAN;
DECLARE @id int
SELECT @id = id + 1 FROM TableA;
UPDATE TableA SET id = @id; --TableA must have only one row, ...
