title: Cache SQL Update for daily reuse
body: <p>I have a big table with 40 million rows in a Table. I am having to update the entire table because I don't want anything to missed. The Update Command Is being used to get the value from a different table and using this to join on.</p>
  
  <pre><code>Update D
  Set D.Key = S.Key
  from Activity D with (NOLOCK)
  inner Join Account S
  on D.ID = S.ID 
  OPTION (HASH JOIN)
  </code></pre>
  
  <p>With Activity D being the Big Table 40 million and Account Table S being a 1.2 Million, that's why I have take the HASH Option Join.</p>
  
  <p>Anyways I am having to do this update everyday in an Execute SQL task in my ETL Process,Just wondering since not much gets changed and no index exist to speed in the process up in the table. Is there a way to speed this process up at all, whether there is a way to cache this so everynight its not having to do the whole thing from scratch or would wrapping this in a Stored Proc speed things up rather than just using a SQL Script as I am doing at the moment?</p>
  
  <p>Thank you </p>