When working out the storage requirements on a per-row basis, how is the size of the NULL bitmap determined?
I know that there are CEILING(n / 8) bytes of NULL bitmap per n columns - but what I don't know is whether there are always two column count bytes or not.
CEILING(n / 8)
Can anyone confirm / deny?
Apr 21 '11 at 02:04 AM
Matt Whitfield ♦♦
I'm sure Klaus covered this in his talk at SQLBits... but I can't remember
According the MSDN, there are the 2 bytes alwas: Null_Bitmap = 2 + ((Num_Cols + 7) / 8)
Estimating the Size of a Heap
Estimating the Size of a Clustered Index
Apr 21 '11 at 02:47 AM
Awesome, cheers - was clearly having an information finding fail day :)
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Apr 21 '11 at 02:04 AM
Seen: 762 times
Last Updated: Apr 21 '11 at 02:04 AM
SSAS Storage Mode
Index Size 3 times bigger than Disk Size
Raid 10 sql2000
How much data is to be transferred from disk ?
Does a persisted computed column need to be deterministic?
Sharepoint - Datafiles - MaxSize
What counters should I baseline before moving to a SAN?
SAN disk with splitting data and logs
SQL Server cluster with shared storage
LOB data on a different filegroup - performance issues/gains?
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.