title: Is it possible to pause an SQL query?
body: <p>I've got a really long running SQL query (data import, etc). It's crap - it uses cursors and it running slowly. It's doing it, so I'm not too worried about performance.</p>
  
  <p>Anyways, can I pause it for a while (instead of canceling the query)?</p>
  
  <p>It chews up a a bit of CPU so i was hoping to pause it, do some other stuff ... then resume it.</p>
  
  <p>I'm assuming the answer is 'NO' because of how rows and data gets locked, etc.</p>
  
  <p>I'm using Sql Server 2008, btw.</p>