Sparse Columns Part 2

In last article we look into what is sparse columns and how to use it. You can visit Part 1 from here
Sparse Column Part 1




Rules for creating sparse columns.

• Sparse Column must be nullable.
• you cant assign default values to sparse columns
• You cant make sparse column as identity or rowguidcol.
• computed columns can not be sparse
• You can not create clustered index/Unique Index/Primary Index on a sparse column.
• You can have 30000 columns as sparse column in a table.
• You can create 1000 index in table with sparse columns.
• A table with sparse columns can not be compressed
• Tables Types cannot use sparse columns
• Sparse columns can not be used with merge replications