Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

E. PollackAnalytics Optimization with Columnstore Indexes in Microsoft SQL Serverhttps://doi.org/10.1007/978-1-4842-8048-5_8

8. Bulk Loading Data

Edward Pollack¹  

(1)

Albany, NY, USA

 

Any analytic data store requires the ability to perform data loads quickly and efficiently. Bulk loading is a reduced logging process that allows data to be inserted directly into a columnstore index. This not only bypasses the delta store, but results in a transaction size that reflects the compression of the target data, greatly reducing the amount of data written to the transaction log when this process is used.

Bulk Load Processes Explained

Traditional transactional workloads ...