Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I was wondering how are null values stored on DISK - is it allocating some minimum bytes - physical disk space as for other columns which have indeed some values and arranged contiguously as the rows are inserted into a table?

and a second question is: if the null values are updated with values, SQL will assign the space needed available at the end of the data file ?

thanks..

share|improve this question

1 Answer 1

up vote 4 down vote accepted

Each row has a null bitmap for columns that allow nulls. If the row in that column is null then a bit in the bitmap is 1 else it's 0.

Pardon me for linking to the cached version of the article from which that is taken.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.