More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
Where is varchar(max) data stored?
In SQL Server 2005, most data for your data types is stored in the pages for the table. Binary objects, such as image or text, are stored in LOB or large Object data pages. Where is varchar(max) data stored?
Answer
In LOB pages
Explanation
Since the size restrictions for varchar(max) are the same as for text data, this data is stored in LOB data pages.
(Continued on next question...)