title: Inserts on to linked server taking long time
body: <p>i have 2 servers (server1 sql server 2008r2 standard, server2 sql server 2014 standard).
  I want to insert some data from server1 to server2 using linked server and i have created thye query like below.</p>
  
  <pre><code>Insert into Linkedservername.dbname.dbo.tablename (col1, col2 )
      select col1, col2 
      from dbo.server1tablename
  </code></pre>
  
  <p>only 20000 records but taking arround 45 minutes.
  If I pull data from server2 then it is taking arround 20 seconds.</p>
  
  <p>Can any one suggest how i can push data with minimum time.</p>