Note: SQL Server Technical Article – The Data Loading Performance Guide by Microsoft
The white paper describes load strategies for achieving high-speed data modifications of a Microsoft SQL Server database.
“Bulk Load Methods” and “Other Minimally Logged and Metadata Operations” provide an overview of two key and interrelated concepts for high-speed data loading: bulk loading and metadata operations.
After this background knowledge, white paper describe how these methods can be used to solve customer scenarios. Script examples illustrating common design pattern are found in “Solving Typical Scenarios with Bulk Loading” Special consideration must be taken when you need to load and read data concurrently in the same table. The section “Bulk Load, NOLOCK Queries, and Read Committed Snapshot Isolation” describes methods you can use to achieve concurrent loading and reading.
This white paper concludes with troubleshooting hints in “Optimizing Bulk Load”.
Abstract courtesy : Microsoft
Reference: Pinal Dave (https://blog.sqlauthority.com)