title: Slow query when connecting to linked server
body: <p>I've got this query </p>
  
  <p><code>UPDATE linkeddb...table SET field1 = 'Y' WHERE column1 = '1234'</code></p>
  
  <p>This takes 23 seconds to select and update one row </p>
  
  <p>But if I use openquery (which I don't want to) then it only takes half a second.</p>
  
  <p>The reason I don't want to use openquery is so I can add parameters to my query securely and be safe from SQL injections.</p>
  
  <p>Does anyone know of any reason for it to be running so slowly?</p>