Sparse columns do not take any space – Using Sparse Columns in SQL SERVER

(Sagitariusmzi) Sparse columns are the new feature in SQL SERVER 2008. Sparse columns are better, when dealing with NULL in SQL SERVER. Sparse columns do not take any space. Defining the column as sparse can save a significant amount of disk space but at the cost of more overhead to retrieve non nul

Read More - Register for Free Membership