I am looking for a solution to a similar problem myself...

I want to export new content from a db table to a remote server on a daily basis, over a...

Maybe...

It appears to be a bug as far as I can see...

Seeing as the table has ~ .5 M records - the difference in io speed is considerable...

Yes the data...

Tried it on same server - still had the problem

did a backup and restore to new db on same server - and the index worked correctly...

I'm confused 🙁

another strangeness:

if...

No this is running on 2 diff servers.

Both running SP2