• I think in the first example (of loading relatively small fact table and switching tables from schema to schema) one step is missing: Step 6 - DROP swap.table.  Otherwise, you will not be able to switch the table from "dbo" to "swap" schema on the next load.