title: How to copy a huge table data into another table in SQL Server
body: <p>I have a table with 3.4 million rows. I want to copy this whole data into another table.</p>
  
  <p>I am performing this task using the below query:</p>
  
  <pre><code>select * 
  into new_items 
  from productDB.dbo.items
  </code></pre>
  
  <p>I need to know the best possible way to do this task.</p>