title: Temporary table vs Table variable
body: <p>I have a table where I have around 1.5 million+ results that I need to delete.  Previously, I was using a temporary table and this caused the transaction log to increase in size quite quickly.  Problem is, once I have done one result set, I need to move onto another where there is another 1.5 million+ results.  The performance of this is rather slow and I'm wondering if I should use a <code>table</code> variable rather than writing a table to the temp database.</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>I use the temporary table when I select the initial 1.5million+ records.</p>