Verifying Minimal Logging for Bulk Load Operations

SQL Server provides several options for bulk loading data, both from other tables and from data files.

In this post I briefly discuss each of them, consider which can be minimally logged, and then demonstrate by looking at transaction log contents when minimal logging really is occurring. […] “Verifying Minimal Logging for Bulk Load Operations”