Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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