Actually, I only set up the second instance to test perfomance of the query on a DB all by itself. I don't plan on running both. But with...

Avg Total = 1389568

Avg Target = 13945438

So I am short on RAM(?)

There is no DROP sentence anywhere in .pre .idx or .sch. That's the part I don't understand. The .idx build a CLUSTERED INDEX out of my PK's (in...

I have looked at those. All the .sch says is to TRUNCATE the table (as I would expect) and to create the table (with no prior DROP table). ...