SQL Server 2012 ... in a columnstore index, Microsoft recommends that you use partitions, and then use partition switching to occasionally update the data. That way, if most updates are simply ...