Sparse Columns: Sparse columns are very much useful while storing 0(Zero) or NULL values. Unlike regular columns, Sparse columns does not consume space in database. This was introduced in SQL Server 2008. As we all know that we can create 1024 columns

Read More