title: Increase precision on money field for huge table
body: <p>I have a huge data table (200+ million records) which stores cash amounts for which we are using the Money datatype. I need to increase the precision of this field to 8 or so decimal points.</p>
  
  <p>Now I could simply go </p>
  
  <pre><code>ALTER TABLE CashTable ALTER COLUMN Cash decimal(23,8) null
  </code></pre>
  
  <p>I would like to know though if anyone has an idea of how this will perform, and whether there is any risk of loss of data.</p>
  
  <p>Thanks</p>