Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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,341 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: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 812 reads

Sparse Columns

By Rajeev Ramadugu 2009/02/20 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 3,397 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: MSSQLTips.com | Category: sql server 2008
Rating:  Rate this |   Briefcase | 2,348 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,181 reads

Sparse Columns

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