title: Converting nvarchar(4000) to nvarchar(max)
body: <p>We have a few tables in our SQL Server (2005 &amp; 2008) database with columns defined as nvarchar(4000). We sometimes need to be able to store more data than that and consider to use nvarchar(max) instead. Now to the questions. </p>
  
  <ol>
  <li>Are there any performance implications we should know of?</li>
  <li>Is it safe to use "alter table" to do the actual migration or is there another way?</li>
  <li>Anything else we should know before we convert?</li>
  </ol>
  
  <p>Regards
  Johan </p>