Browse by Tags

• sparse column

• My future posting related to semi-structured.

  Hello, In this blog entry, I will provide a list of topics I will cover in further blogs. When to use and How to use Filtered Indices. Introduce to the Column Set XML Column and Wide Table feature in SQL Server 2008 Redesign the Project Management System Read More... Posted Friday, January 09, 2009 4:56 AM by Qingsong Yao | 1 Comments Filed under: sparse column, column set Attachment(s): Project Management.ppt

• Using SQL Server 2008 Semi-Structured features for Performance Tuning and Application Design (1)

  Before I talk with the examples of semi-structured property management system, I like to define the semi-structured data: · Group: A set of ordered, open, heterogeneous properties. Every group has a name and every property in the group. · Object: An instance Read More... Posted Wednesday, September 10, 2008 5:47 PM by Qingsong Yao | 1 Comments Filed under: sparse column, column set Attachment(s): Get_Sparse_Info.sql

• Sparse Column Storage

  In SQL Server 2008, we implemented a set of features, including Sparse Column, Column Set + Wide Table, Filtered Index and HierarchyID, to support Semi-Structure data management. Today, I will talk about how Sparse Column will save disk space. When a Read More... Posted Wednesday, September 03, 2008 7:25 PM by Qingsong Yao | 1 Comments Filed under: sparse column, column set