Sparse Columns in SQL Server : Impact on Time & Space

(Erin Stellato) SQL Server 2008 introduced sparse columns as a method to reduce storage for null values and provide more extensible schemas. The trade-off is that there is additional overhead when you store and retrieve non-NULL values. I was interested in understanding the cost for storing non-NULL

Read More - Register for Free Membership