Details:
SQL 2000 standard on both boxes
I have a 319 record table on one server. I have to run it against a 65 million record table on another server, and update 4 columns in the smaller table. Same server, this runs in seconds. Across servers, it runs forever (at least it seems like forever). I've tried openquery, with minimal reduction in time. I'm trying to solve this without having to shift the table between servers. Any help would be appreciated.
UPDATE importFile
SET CC = Z2.CC,
CD = Z2.CD,
SS = Z2.SS,
SH = Z2.SH
FROM importFile a
INNER JOIN sqlserver3.remotedb.dbo.remotetable Z2
ON a.STATE = Z2.STATE AND a.zipcode = Z2.zipcode
go