title: Efficiently add a column with a value
body: <p>I am trying to add a column to a tsql table, i do this using SMO in c#. Altering the table is fine but i want to set the column to have a value. The table contains 650 million rows and the update query is taking over a day and a half to run. </p>
  
  <p>Update [TempDatabase].[dbo].[table1] set RawSource = 'DTP' </p>
  
  <p>This is the query I am running above. </p>
  
  <p>Can anyone think of a more efficient way of doing this?</p>
  
  <p>Thanks in advance.</p>