Home Forums SQL Server 2008 SQL Server 2008 - General Not seeing savings in sparse columns RE: Not seeing savings in sparse columns
winston Smith
SSCoach
Points: 19498
More actions
March 3, 2013 at 8:38 am
#1592761
opc.three (3/3/2013)NULL variable-length columns are returned as NULL based on the metadata of the table (and the NULL-bitmap of the record) when the result set is constructed but occupy no space on the data page.
opc.three (3/3/2013)
That's very helpful. Thanks a mil!