THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » ColumnstoreInde... » Performance   (RSS)
  • Updateable columnstore index gotchas

    SQL Server 2014 introduces updateable nonclustered and clustered columnstore indexes. When new data is inserted, it goes first to deltastore where background process divides it into row groups, indexes and compresses. Indexing progress can be observed via sys.column_store_row_groups DMV. According to BOL, row groups in deltastore can be in one of ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on December 1, 2013
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement