title: Set a column to NULL without generating transaction log
body: <p>I have a 15GB database with some binary data that accounts for 50% of the database. I want to remove that unneeded data but my transaction log is going to explode in size. What are my options?</p>
  
  <p>I can only delete one column data: 
  <code>UPDATE t SET binData=NULL WHERE binData IS NOT NULL</code></p>
  
  <p>And yes, the space might be the problem: hence my question. I need to do this on 1000+ databases (most of them are cca 1-2GB). I don't have 2x space available </p>