Sparse Columns Archives - SQLServerGeeks

SQL Server What is a Sparse Column?

January 15, 2012September 22, 2014 - by Piyush Bajaj - 1 Comment

Hello Folks, You would have heard about Sparse Column.It has been introduced earlier with the arrival of SQL Server 2008. Well I have made some keynotes about SQL Server What is …

SQL Server

Sparse Columns in SQL Server 2008

May 4, 2011December 18, 2014 - by Sachin Nandanwar - 2 Comments.

Prior to SQL Server 2008 there was a lot of space wastage due to the storage of the NULL bitmaps for tracking NULL values in columns defined as NULL.SQL reserves the …