Sabin.io | Automating SQL Server Performance Testing
Refreshing SQL Server Tables With Less Interruption Using Partition Switching - SQLPerformance.com
Aaron Bertrand talks about using partition switching to load refreshed SQL Server tables without impacting current users.