The slowest operation on most computer systems is I/O (input/output), such as reading data from and writing data to the storage system (the hard disks). How fast data is processed is vital to both online and batch operations.  Nothing exposes a poorly performing disk subsystem than Bulk Insert tasks, since I/O latency is of significant impact on throughput.  The Bulk Insert task provides an effective way to move large amounts of data into a SQL Server table.

The following video demonstrates 96 parallel Bulk Insert tasks.

To download and view video demonstration, please click here.