Sounds to me like what you need is a nightly job to handle this.  Run a DTS package to move over the new records / update changed records and then...

<cynic alert>

I've got relatives that work for the USPS.  If past history is any indication, they're using these things to track employees and pressure them to artificial levels of "productivity".

</cynic...

No, that's not what I was talking about.

In my case, I had a lookup going to a OLE DB Destination.  I wanted to change that to go first to a...

What are the results of this part of your query on each server?

select evox_id from vehicle_tmp v where v.vehicle_nmb = nimages.vehicle_nmb

Table design discussions set aside, this should get you waht you want:

select

s1

.Location2,

s1

.Location1,

Found it.  Typo on the main books page has SQL Server 2000 listed twice.  Second one is 2005 books.

Thanks.  I don't see anything for 2005 up yet.

The last shop I worked at had the same perspective - they were doing some testing of 2005 but didn't want to convert yet.  Their biggest hesitation was the DTS...

Have you run a DBCC SHOWCONTIG to verify this?

I just thought of something...

A newly restored DB should have no fragmentation (or very minor fragmentation).  You should take a look at that as well.

I don't know.  It might not.  Can't find anything that says one way or the other.  That would just be my first line of investigation.

You might also want to look...

What kind of information are you looking for?

Coincidentally, Steve Jones posted an article today that discusses using Profiler (in a different context but it should help you out).  You can...

Profiler should be your first line if investigation, then.

You could also potentially put a trigger on the table to capture data, but I'd start with Profiler.

Doubtful.  From BOL:

"

Columns that already have statistics are not touched; for example, the first column of an index or a column with explicitly created statistics. A CREATE STATISTICS statement is...

stats would be my fist guess.  Try this:

STATS_DATE ( table_id , index_id )