title: SQL Updating and Inserting dupcliate tables with linked server
body: <p>SQL Server 2012 (local) to SQL Server 2005 (Linked)</p>
  
  <p>I need to keep the (linked) server in sync with the local server which includes about 2-3 tables only (not the whole database).  This is not really time sensitive so I don't want to use triggers and such.  We just want to have this run 1-2 times per day as a scheduled task.</p>
  
  <p>I have tried:</p>
  
  <p>DELETE FROM linked_server</p>
  
  <p>INSERT INTO linked_server
  (value1,value2,value3)
  SELECT value1,value2,value3) FROM local_server</p>
  
  <p>But the process is taking like 45 minutes plus to run.  I would like to do something more quickly - I have searched and searched but really can't find any good solution (that is in my level of understanding).</p>
  
  <p>Typically we're talking only 30 records or so are either updated or inserted.</p>
  
  <p>Any suggestions.</p>