Sparse Column is one more new feature introduced in SQL SERVER 2008. Storing a null value in a sparse column doesn’t take any space, but storing a non-null value in sparse column takes 4 bytes extra space than the non-sparse columns of the same data type. For example: As we know that storing a null/non-null … Continue reading Sparse Columns in SQL Server 2008