A reader got Msg 511 when adding a sparse column. Sparse columns reduce the maximum row size from 8060 to 8018 bytes. Here is what that means for you.
SQL SERVER – CREATE TABLE Failed Because Column ‘C1024’ in Table ‘myTable’ Exceeds the Maximum of 1024 Columns
Sparse columns should let a table go past 1024 columns, yet a reader’s CREATE TABLE failed saying it exceeds the maximum of 1024 columns. Here is why.
Space Used by Sparse Data: How SPARSE Columns Save Bytes
Space used by sparse data depends on how many values are NULL. This post loads 100,000 coupons into a normal table and a SPARSE table, measures the row size and the pages, and finds the point where SPARSE stops paying off. It also shows that a NULL in a sparse column costs nothing, and that a value costs more than usual.
SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2
Part 2 on SPARSE Columns in SQL Server 2008: how they are stored as one XML column, plus the main advantages and the limits you should know about.
SQL SERVER – 2008 – Introduction to SPARSE Columns
A quick introduction to SPARSE Columns in SQL Server 2008, which take almost no space for NULL and zero values. Learn the basics and the 100,000 column limit.




