What are the advantages of Sparse Column?

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

- Eliminate the limit of maximum allowed column in SQL Server 2008 per table which is 1024.The maximum limit of SPARSE column is 100,000.So we can have 1024 + 100,000 columns.

- When there is a need to save 20-40% of space or a significant percentage of the rows to have a Zero or NULL value we can go for Sparse column.

- Sparse columns works well with filtered indexes because we create index for dealing with the non-empty attributes in the column.

- It was developed to be use in Content management systems like SharePoint which is one of the key drivers for File Stream project.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response