Total Pageviews

How does SQL Server really store NULL


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

For variable size data types the actual size is 0 bytes.

For fixed size data type the actual size is the default data type size in bytes set to default value (0 for numbers, '' for chars).




No comments:

Post a Comment