Browse by Tags

Tagged Content List
  • Blog Post: 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 Tuning and Redesign a row-per...
  • Blog Post: 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 of a group. · Property: A scalar...
  • Blog Post: 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 table has no sparse column defined, and no data...
Page 1 of 1 (3 items)