Your Ad Here

Apr 8, 2008

Which of the following is not an allocation unit in SQL Server 2005?

TEXT_IN_ROW_DATA
The three types of allocation units are: IN_ROW_DATA, LOB_DATA, and ROW_OVERFLOW_DATA. Each heap or index has IN_ROW_DATA which holds part of the data. LOB_DATA is used for large object data types and ROW_OVERFLOW_DATA is used for varible length data that causes a row to exceed the 8060 byte limit.

No comments: