What are the limitations of Sparse Column?

 Posted by Niladri.Biswas on 7/18/2012 | Category: Sql Server Interview questions | Views: 1284 | Points: 40

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 | Alert Moderator 

Comments or Responses

Login to post response