Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags SQL Server 2008, Sparse Columns Rss

   Items 1 to 3 of 3   
 

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,332 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,177 reads

Sparse Columns

By Steve Jones 2008/07/17 | Category: sql server 2008
Rating: (not yet rated) |  Discuss |   Briefcase | 2,589 reads
   Items 1 to 3 of 3