Thanks Elliot, in the end SSIS is probably what we will go with. Can you point me in the general direction of getting started with it?

Do I need to...

I'm not sure that replication is the answer.

We have a database with all of our customer's data ServerA, and we have another database with just one customer's data ServerB.

The data...

Well, the devices have stopped buzzing at me now after several days...

I rebuilt the indexes one time, took several hours, and even with DoubleTake, failing over/back is a huge pain...

Well, I just checked and auto-update is ON for every index in the relevant tables.

At one point, I did use the index tuning wizard and it doesn't suggest to use a different...

Can't if that would require modifying the applications, no stored procedures are used for the applications, and they...

Mike, that's what I did. Before I posted, I had already run a trace with profiler, found the problem query, determined the execution plan in Query Analyzer, and noticed it...

I agree with Newbie, I saw the space in the path, looked at the Filename list, and found no indication of a space prefix, so I immediately chose the first...