Large Value Types out of Row Option

varchar(max), nvarchar(max), and varbinary(max) are collectively called large-value data types. You can use the large-value data types to store up to 2^31-1 bytes of data.

When the sp_tableoption stored procedure 'large value types out of row' option is set to OFF, the in-row storage limit for large-value types is 8,000 bytes.

To support a more than 8,000 bytes data type, run:
USE AdventureWorks
sp_tableoption 'HumanResources.JobCandidate', 'Large Value Types Out Of Row' ,1