Tagged Questions
0
votes
3answers
72 views
Importing data with a lot of SELECTS during transaction
I'm using SQL server 2008 R2 and I have a products table with an auto increment integer id column as primary key and a product_no column (unique) and 6 tables like articles and product_assets which ...
1
vote
1answer
363 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 ...
7
votes
3answers
894 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
...
