2
votes
5answers
3k views

Combine Table Hints INDEX and FORCESEEK with Two Joins Not On PK

See first query below. Can NOT combine table hint Index and forceseek with two joins and the joins are not on the PK. How to make the first query compile? Interesting - if just one join or the other ...
7
votes
1answer
4k views

OPTION FORCE ORDER improves performance until rows are deleted

I have a somewhat complex SQL Server 2008 query (about 200 lines of fairly dense SQL) that wasn't performing as I needed it. Over time, performance dropped from about .5 seconds to about 2 seconds. ...
1
vote
0answers
192 views

What overhead is there if I MERGE row by row?

I have a target table of about 2000 rows and I want to be able to MERGE (with HOLDLOCK) about 5-10 rows at a time into the target table. The target table doesn't get used heavily, with only 1-2 users ...
2
votes
1answer
411 views

Locking, deadlocking workaround while process data at the same table

My database has a table: tableX. Task1 makes intensive INSERTs (1000 records per minute) as records to process and very seldom UPDATEs (1-2 records per minute) as records to recalculate. At the ...