Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

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 read somewhere online and in a Microsoft Press book there is a field declaration attribute that can be used to indicate NULL VARCHAR values should not consume space at the leaf-level instead of consuming a few characters per leaf.

Could someone help me identify where that attribute is?

I cant remember what the Attribute keyword is but I remember seeing it because of the value of saving the empty 2 bytes and make it a 0 byte storage for no data.

share|improve this question
Pretty sure you are asking about SPARSE columns. Do you have further questions about them, or did you just need to be reminded what they're called? – Aaron Bertrand Jul 13 '12 at 18:43
I knew it was new to 2008(r2) but couldnt remember the keyword for the new attribute for varchar data type. – GoldBishop Jul 15 '12 at 6:15
up vote 6 down vote accepted

I believe you are talking about SPARSE columns.

share|improve this answer

Your Answer


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.