April 8, 2011 at 7:18 am
Until I heard about SPARSE column I thought NULL does not consume any space :smooooth:. How is the storage architecture of a NULL? Appreciate any answer/link for the same.
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 8, 2011 at 9:44 am
Here is a good start explaining how NULLs are tracked by the storage engine at the page level in non-sparse columns: http://www.sqlskills.com/BLOGS/PAUL/post/Misconceptions-around-null-bitmap-size.aspx
And some info about Sparse Columns: http://www.sqlskills.com/BLOGS/PAUL/category/Sparse-Columns.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 8, 2011 at 9:56 am
Thank you very much 🙂
_____________________________________________
One ounce of practice is more important than tonnes of dreams
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply