Bulk Loading data into COLUMNSTORE table

Bulk loading is the most performant way to move data into a columnstore index because it operates on batches of rows. Bulk loading fills rowgroups to maximum capacity and compresses them directly into the columnstore. Only rows at the end of a load that don’t meet the minimum of 102,400 rows per rowgroup go to the deltastore. For understanding bulk load and minimal logging see Fastest Data Loading using Bulk Load and Minimal Logging
Read more Bulk Loading data into COLUMNSTORE table

Bulk Loading data into HEAP versus CLUSTERED Table

Bulk Loading into HEAP

Generally, the fastest way to load data into SQL Server table is by Bulk Loading data into HEAP using TABLOCK hint on destination table which facilitates minimally logging. For more details see Fastest Data Loading using Bulk Load and Minimal Logging 
The few constraints for loading data minimally logged using TABLOCK hint:

  • The database must be in simple or bulk logged recovery model.
  • The destination table must be without Clustered Index.
  • There must be no NON-Clustered index on the destination table.

Read more Bulk Loading data into HEAP versus CLUSTERED Table