DBA > Job Interview Questions > Microsoft SQL Server FAQs

What's an allocation unit?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What's an allocation unit?

Answer: A collection of pages in a table based on page type.
Explanation: An allocation unit is a collection of pages within a heap or B-tree. It is based on on the page type (LOB data in row, LOB data out of row, overflow data). It can be of any size and crosses extents.

(Continued on next question...)

Other Job Interview Questions