Where is varchar(max) data stored?

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...)

Other Job Interview Questions

• A .NET assembly running with UNSAFE permissions can do which of the following?
• Which of these is not a parameter you can pass to the LOGINPROPERTY function?
• What's SQL Server
• What is a primary key? What is a foreign key?
• What value should you use for the BROKER_INSTANCE parameter?
• In SQL Server 2005, which network protocols use endpoints?
• What is the timestamp datatype used for?
• The nesting level for stored procedures in SQL Server 2005, but how many databases can you access inside one stored procedure?
• Which of the following CREATE ASSEMBLY statement WITH PERMISSION_SET clauses sets ...
• You are looking to secure your publisher to prevent unauthorized logins from accessing the data through replication. Where do you add the list of logins that have access?
• More...