Year: 2014

Clustered Column Store Index: Bulk Loading the Data

by Sunil Agarwal // 4 Comments

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 data load with fast query performance. Multiple inserts can load the data in parallel concurrently while DW queries are being run in read uncommitted transaction isolation level. This… Read more

Clustered Column Store Index: Concurrency with INSERT Operations

by Sunil Agarwal // 2 Comments

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 trickle data load with fast query performance. Multiple inserts can load the data in parallel concurrently while DW queries are being run in read uncommitted transaction isolation level. This blog… Read more

Clustered Column Store Index: Concurrency and Isolation Levels

by Sunil Agarwal // 2 Comments

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 the data in columnar format, processing set of row in batches… Read more

Clustered Column Store: Factors that impact size of a RowGroup

by Anonymous // 0 Comments

  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. Compressed rowgroup:  stores rows in columnar storage… Read more