a) Microsoft recommends to use sparse columkn if there is a need to save space by at least 20 to 40%.
b) For Sparse column to act on a specific column, it must be nullable and cannot be configured with the ROWGUIDCOL or IDENTITY properties.
c) Sparse Columns cannot include Default value.
d) We cannot make a sparse column for TEXT, IMAGE, or TIMESTAMP datatypes.
e) I cannot be part of a clustered index.
f) It cannot be a unique primary key index.
Asked In: Many Interviews |