I skimmed through it because it's a bit beyond my current level of knowledge. I will roll up my sleeves and dive in.

Thanks for the advice!

I figured that rebuilding would make for cleaner indexes. Is this not the case? Does the script you're linking me to do a good enough job without rebuilding?

I just picked it from the maintenance plan wizard. The Tsql is auto-generated.

I was wondering what useful info you'd get from that. Ha!

Trace File

Here's the xml file exported from my trace. How's that? I included all of the Lock...

Here's the deadlock graph. Do you need anything else?

Thank you! I'm not sure how I missed that cross join, but sometimes it takes askin' to get it.

Final query went like this

SELECT DISTINCT...