Rebecca Lewis swaps in a bag of sand while snatching the golden idol:
Use ALTER TABLE … SWITCH to move very large tables instantly. Yes. I said instantly. ALTER TABLE .. SWITCH doesn’t copy the data or physically move it. It just reassigns the page ownership. This means that only the metadata with the data pointer changes, and that’s why it completes in milliseconds and barely touches the transaction log.
There are some strict conditions around when you can use this technique, but it’s as powerful as Rebecca mentions.