title: Max Row Size in SQL Server 2012 with varchar(max) fields
body: <p>I have created a table with column types as <code>nvarchar(max)</code>, which my understanding is that they can support 2GB. However on inserting, I still receive this error:</p>
  
  <blockquote>
    <p>Cannot create a row of size 8061 which is greater than the allowable maximum row size of 8060.</p>
  </blockquote>
  
  <p>Is there a global setting on the database required, or is there another limit I am hitting? Is there a limit to the number of <code>varchar(max)</code> fields per table?</p>