title: SQL Server: after converting from image to varbinary(MAX), should I update the converted column?
body: <p>I have a 200GB table with a column of type <code>image</code>, which I'm planing to convert to a <code>varbinary(MAX)</code>. After reading this post about converting <code>NTEXT</code> <a href="http://geekswithblogs.net/johnsPerfBlog/archive/2008/04/16/ntext-vs-nvarcharmax-in-sql-2005.aspx" rel="nofollow noreferrer">http://geekswithblogs.net/johnsPerfBlog/archive/2008/04/16/ntext-vs-nvarcharmax-in-sql-2005.aspx</a> the writer suggest to do an </p>
  
  <pre><code>UPDATE testTable 
  SET testText = testText
  </code></pre>
  
  <p>After the conversion. Can the same be applied to a conversion between <code>image</code> and <code>varbinary</code>?  </p>