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.

A server application stores data in an SQL Server 6.5 database. A customer id number is entered into the client application, and after retrieving data from the server, the client displays a list ...