title: Fastest way to update 120 Million records
body: <p>I need to initialize a new field with the value -1 in a 120 Million record table.</p>
  
  <pre><code>Update table
         set int_field = -1;
  </code></pre>
  
  <p>I let it run for 5 hours before canceling it.</p>
  
  <p>I tried running it with transaction level set to read uncommitted with the same results.</p>
  
  <pre><code>Recovery Model = Simple.
  MS SQL Server 2005
  </code></pre>
  
  <p>Any advice on getting this done faster?</p>