Sparse columns of sql server 2008

Question

Explain about the sparse columns of sql server 2008.

Answer 1

A column along with an optimized storage for null values is termed as sparse column. Sparse columns decrease the storage space requirements for null values. Within a scenario of saving 20 percent to 40 percent of storage space, sparse columns can be seemed. They are created by using CREATE or ALTER TABLE statement.

A huge number of user defined properties can be accessed with using sparse columns and filtered indexes allowed applications like Share Point Services of windows are efficiently access and store.