Related resources for NULL Values Using Sparse Columns
  • Memory Handling on NULL Values Using Sparse Columns5/20/2012 2:23:33 AM. Sparse columns is a new feature in SQL Server 2008. Thr feature enables us to store null values effectively. Ideally, if the column is NULL, then the data won't be stored in the database and it's cost effective solution to save the space. If your table has more Null values, we can use this solution.