Home > DeveloperSection > Interviews > What are Sparse Columns in SQL?

Posted on    August-21-2014 12:05 AM

 MSSQL Server MSSQL Server 
Ratings:
 1 Answer(s)
  852  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Points:3910
Posted on    August-21-2014 12:00 AM

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 nonnull values.


Don't want to miss updates? Please click the below button!

Follow MindStick