Answer:
- 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