Use of Sparse Columns in SQL Server 2008

When to use Sparse Columns

Sparse columns consumes less storage for null values.It reduces the space needed for NULL values.Try to use sparse column,if ur column is going to have more NULL values.

Syntax:

CREATE TABLE EMP(empID int Primary key, ename varchar(100) SPARSE NULL);
GO