Hi friends,
I want to know,what are sparse columns?
Thanks
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Priya LingePosted Nov 10, 2011, 6:42 AM
1.If the value of a column is NULL, it doesn't consume space at all.
Sparse columns reduce the space requirements for null values at the cost of more overhead
to retrieve nonnull values.
2.Support of having 30000 sparse columns in a table.
3.It stores the data in a single xml column but for an external application it behaves like a normal column.
4.SPARSE column can take advantage of filtered Indexes, where data are filled in the row.
Hope this will help you.
Thanks.
Deepak DwijPosted Nov 12, 2011, 6:12 AM
Karthik AgarwalPosted Nov 10, 2011, 5:43 AM
http://blogs.extremeexperts.com/2011/01/10/sparse-columns-need-and-limitation
Javeed M ShaikhPosted Nov 9, 2011, 1:01 PM
Read this article to know more..
http://msdn.microsoft.com/en-us/library/cc280604.aspx