LongBinary read

May 9, 2011 at 3:06 PM

If you have a LongBinary column that is > 1024 bytes (so it's in a separate B-tree), does reading any column from the record read the binary column from the separate b-tree or that is that only read if the binary column is read?

May 9, 2011 at 4:57 PM

A separated long-value is only read off disk if you specifically retrieve that column.

May 9, 2011 at 7:44 PM

Excellent. That's what I would have assumed, but you know what they say about assumptions....