The lesser known SPARSE Column in MS SQL SERVER
Introduced in SQL Server 2008, The SPARSE column is better at managing database size when null values are a plenty in that particular column.To declare a particular column as sparse we have to simply specify the keyword 'sparse' after declaring the column name and the data type. Please refer to the below
Read more