Posted In: Null Values

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

This Article is TAGGED in column size, Null Values, SPARSE, SQL Space management. Read more