In SQL Server, updates and inserts are processed initially into a B-tree table called a delta store. Eventually, a process called a tuple mover compresses the data into the columnstore structure.

“Database administrators can [elect] to store data in a row store, column store or in both types as necessary,” the company said Sept. 15.