|Subject:||Update Table on another server|
|Date:||Wed, 6 Jan 2010|
I am trying to update data from one server to another server.
To run this query takes 20 seconds when trying to update one record.
Anyone have ideas on how I can improve/optimize the speed.
Currently using SQL Server 2005
I am running this query from Server1:
Set Title = Table1.Title
Where ID = tp.PLU
Server1:DB1:Table1 (this file is small and contains information on which
records need updating)
40, 'New Title'
Server2:DB2:Table2 (this file is larger (over 20K records))
thanks in advance.