Loading strategies: Strategy When SQL pattern Full refresh small tables TRUNCATE + insert (in a transaction) Append immutable events/logs INSERT only Upsert / merge dimensions, changing records INSERT … ON CONFLICT DO UPDATE / MERGE Partition swap large fact tables load a partition, then switch it in Performance Insert in batches (executemany, COPY, BULK INSERT, SSIS fast load) — never row by row with a commit each. Load into a staging table first, then merge into the target in one set-based statement. Disable/rebuild non-clustered indexes for very large loads. Wrap each batch in a transaction so a failure leaves no half-loaded data.