title: SQL server Varchar(max) and space taken
body: <p>If <code>varchar(max)</code> is used as the datatype and the inserted data is less than the full allocation, i.e. only 200 chars, then will SQL Server always take the full space of <code>varchar(max)</code> or just the 200 chars' space?</p>
  
  <p>Further, what are the other data types that will take the max space even if lesser data is inserted?</p>
  
  <p>Are there any documents that specify this?</p>