improve.dk
Just another mindless drone looking for the perfect stack
posts - 220, comments - 475

SQL Server: Null Bitmap


The garbage null bitmap and why you can’t rely on it solely

Written on Saturday, July 16, 2011 by Mark S. Rasmussen in SQL Server: Internals, SQL Server: Null Bitmap

Don't trust bits in the null bitmap as they may contain garbage. Here's an example of how it may occur and why it doesn't matter.

No comments | Write first comment
 

The null bitmap is *not* always present in data records

Written on Friday, July 15, 2011 by Mark S. Rasmussen in SQL Server: Internals, SQL Server: Null Bitmap, SQL Server: Sparse Columns

Contrary to popular belief, the null bitmap is not always present in data records. Here's an example of a data record that doesn't contain a null bitmap due to using sparse columns.

5 comments | Read comments