title: Linked Server Insert-Select Performance
body: <p>Assume that I have a table on my local which is <code>Local_Table</code> and I have another server and another db and table, which is <code>Remote_Table</code> (table structures are the same).</p>
  
  <p><code>Local_Table</code> has data, <code>Remote_Table</code> doesn't. I want to transfer data from <code>Local_Table</code> to <code>Remote_Table</code> with this query:</p>
  
  <pre><code>Insert into RemoteServer.RemoteDb..Remote_Table
  select * from Local_Table (nolock)
  </code></pre>
  
  <p>But the performance is quite slow.</p>
  
  <p>However, when I use SQL Server import-export wizard, transfer is really fast.</p>
  
  <p>What am I doing wrong? Why is it fast with Import-Export wizard and slow with insert-select statement? Any ideas?</p>