http://blogs.msdn.com/sqlserverstorageengine/archive/2008/02/04/what-are-the-bulk-import-optimizations.aspxBulk import provides an optimized insert path that minimizes this overhead with following optimizations · Minimal Logging: under this logging mode, individual rows are not logged and only the changes to page allocation structures are logged. This reducesenCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/sqlserverstorageengine/archive/2008/02/04/what-are-the-bulk-import-optimizations.aspx#7476755Wed, 06 Feb 2008 01:03:41 GMT91d46819-8472-40ad-a661-2c78acb4018c:7476755SELECT IsUseless(blabber) from sys.innarwebs CROSS APPLY jmass(blog)<p>The big news of the week is Windows Server 2008 RTM'ing. Read more here. The storage engine team has begin a series on bulk insert. It is definitely recommended reading. Part 1, Part 2, Part 3. The S ...</p>