title: Bulk Insert from table to table
body: <p>I am implementing an <strong>A/B/View</strong> scenario, meaning that the <strong>View</strong> points to <strong>table A</strong>, while <strong>table B</strong> is updated, then a switch occurs and the view points to table B while table A is loaded.</p>
  
  <p>The switch occurs daily. There are millions of rows to update and thousands of users looking at the view. I am on SQL Server 2012.</p>
  
  <p>My questions are:</p>
  
  <ul>
  <li>how do I insert data into a table from another table in the fastest possible way? (within a stored proc)</li>
  <li>Is there any way to use BULK INSERT? Or, is using regular insert/select the fastest way to go?</li>
  </ul>