Subject Re: DB w/ 16kb page site and BLOB fields size w/ content just 40bytes by record
Author Dmitry Yemanov
22.11.2012 1:16, Leyne, Sean wrote:
> If that size is less than the free space on the data page, then the blob
> would be stored with the data, taking only 40 bytes.

I'd say it gonna take 8 bytes per blob id + up to 8 bytes per alignment
(both compressed) + 28 bytes per blob header (uncompressed) + 40 bytes
of data (uncompressed).