I have found that >95% of the time, software optimization (index tuning) will scale better than throwing hardware at it.  It's going to be cost prohibitive to keep throwing thousands...

Here's another wild idea. Is there really any reason to use a temp table? How about sticking the results into a real table with a unique ID for...

I've taken some time to experiment with rbarryyoung's 3 recommendations. Here's what I have come up with so far.

1. Yes, this is the approach we're using, but doesn't...

I believe indexed views require SQL Server Enterprise, but we're only running standard. In addition, do any of your other recommendations require Enterprise to implement?

RBarryYoung:

I see your points on deadlocking. We'll leave that part out of the discussion for the sake of simplicity. My main objective was to see if there's a...

I'll address each of your questions respectively:

1. After further review, it doesn't appear the deadlocks are coming from this process, but rather from some other ones. This...

I've written up some sample code to illustrate what I have so far. It would seem there is a lot of overhead with inserting the records into the temp...