#28 Claims that (n)varchar(max) is stored off-page

[brianary]

unless the large value types out of row option is set to ON, varchar(max), nvarchar(max), varbinary(max), and xml columns are stored, if it is possible, inside the data row.
― TechNet: SQL Server: In-Row Data