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 9 of 9   

Sparse Columns in SQL Server : Impact on Time & Space

Erin Stellato (@erinstellato) looks into sparse columns in SQL Server ā€“ the changes to space requirements and the impact on the write portion of your workload.  Read more...
By Additional Articles 2016/03/15 | Source: | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 3,166 reads

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,383 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 | 914 reads

Sparse Columns

By Rajeev Ramadugu 2009/02/20 | Category: datatypes
Rating: (not yet rated) |  Discuss |   Briefcase | 3,417 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,422 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,221 reads

Sparse Columns

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