Looking into SPARSE Columns in SQL Server
In this rather short post I would like to provide you with a hands-on example on SPARSE columns. Sparse columns are very useful when we have tables and columns with many zero and NULL values.This feature was introduced in SQL Server 2008.We have a better more efficient way to manage empty space through SPARSE columns by enabling NULL data to consume no space at all.(
read more)