What are Sparse Columns in Sql Server 2008?

 Posted by Sumank on 5/17/2013 | Category: Sql Server Interview questions | Views: 1562 | Points: 40

A sparse column is another tool used to reduce the amount of physical storage used in a database. They are the ordinary columns that have an optimized storage for null values. Sparse columns reduce the space requirements for null values at the cost of more overhead to retrieve non null values.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response