Browse by Tags

Tagged Content List
  • Blog Post: Clustered Column Store Index: Bulk Loading the Data

    Clustered Column Store: Bulk Load As described in the blog http://blogs.msdn.com/b/sqlserverstorageengine/archive/2014/07/27/clustered-column-store-index-concurrency-and-isolation-level.aspx , the clustered column store index has been optimized for typical DW scenario supporting nightly or trickle...
  • Blog Post: Clustered Column Store Index: Concurrency with INSERT Operations

    Clustered Column Store: Insert Operations As described in the blog http://blogs.msdn.com/b/sqlserverstorageengine/archive/2014/07/27/clustered-column-store-index-concurrency-and-isolation-level.aspx , the clustered column store index has been optimized for typical DW scenario supporting nightly or...
  • Blog Post: Clustered Column Store Index: Concurrency and Isolation Levels

    Clustered Column Store and Concurrency The clustered column store index (CCI) has been designed for Data Warehouse scenario which primarily involves Write once and read multiple times – CCI is optimized for query performance. It give order of magnitude better query performance by compressing...
  • Blog Post: Clustered Column Store: Factors that impact size of a RowGroup

    Clustered Column Store: Factors that impact size of a RowGroup: A clustered column store index stores rows in columnar storage format in group of rows, referred to as rowgroups. There are two types of rowgroups as follows: Delta rowgroup – stores data in traditional row storage format...
Page 1 of 1 (4 items)