Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Sparse Columns Rss

   Items 1 to 8 of 8   

NULL-Friendly: Using Sparse Columns and Column Sets in SQL Server

Sparse columns and column sets in SQL Server 2012 provide a way of accomodating the less-structured data that has always proved to be tricky for the relational model. They can be used very effectively where the attributes are sparse for any given entity and very numerous across all entities. Seth Delconte shows how to use them.  Read more...
By Additional Articles 2012/07/26 | Source: SimpleTalk | Category: sparse columns
Rating:  Rate this |   Briefcase | 1,379 reads

Sparse Columns – ConvertSVtoXML & XMLToResv

Not very often I run across something with zero matches in a search engine, but had it happen recently. I had set up a simple demo of a sparse column set and happened to look at the execution plan, was interested to see that the Compute Scalar was backed by ConvertSVtoXML. This was on a select from a table with one row, and then, being a little more curious, updated it with an xml fragment I saw a call to ConvertXMLtoResv. I’d venture that those serve to convert back/forth from XML storage.  Read more...
By Andy Warren 2009/10/15 | Source: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 894 reads

Sparse Columns

By Rajeev Ramadugu 2009/02/20 | Category: datatypes
Rating: (not yet rated) |  Discuss |   Briefcase | 3,410 reads

SQL Server 2008 Sparse Columns Identifying Columns For Conversion

SQL Server 2008 has introduced a new way to store data for columns that contain excessive NULL values called Sparse Columns. What this means is that when you declare a column as Sparse and any time a NULL value is entered in the column it will not use any space. Is there a way to identify what columns would make a good candidate for this without having to analyze each column individually?  Read more...
By Additional Articles 2008/12/15 | Source: | Category: sql server 2008
Rating:  Rate this |   Briefcase | 2,418 reads

Using Column Sets with Sparse Columns

This article provides an overview of the use of Column Sets with Spare Columns in SQL Server 2008  Read more...
By Additional Articles 2008/07/30 | Source: SQL Server Performance | Category: sql server 2008
Rating:  Rate this |   Briefcase | 2,220 reads

Sparse Columns

By Steve Jones 2008/07/17 | Category: sql server 2008
Rating: (not yet rated) |  Discuss |   Briefcase | 2,597 reads
   Items 1 to 8 of 8   
sql server 2008 (3)    
t-sql (2)    
blogs (1)    
datatypes (1)    
select into (1)    
sparse column sets (1)    
table value constructor (1)    
xml (1)