title: SELECT * INTO #testtable query takes quite a bit of time?
body: <pre><code>select TableA.Sys_ID, TableA.State_Code, 
      TableA.Zip_Code, TableA.Birth_Date, TableA.Gender, 
      TableA.Source_code, TableB.Sys_ID
  into #testtable
  from DM.TableA
      inner join DM.TableB
      on TableA.Sys_ID = TableB.Sys_ID;
  </code></pre>
  
  <p>TableA has about 130 million records, while TableB has about 600 million records. I have aborted my query multiple times after 15 minutes, because I don't want to clog up access to the database across the company. Is there anything I can do to optimize my code for greater load speed, or is it simply a matter of time before the job completes?</p>