February 2008 - Posts

• Bulk Import Optimizations (Minimal Logging)

  In the previous blog I had listed all bulk import optimizations. Now, I will describe each of these optimizations in detail in separate blog entries. Let me first start with minimal logging. By the way minimal logging is also called bulk-logging but the Read More... Posted Tuesday, February 05, 2008 3:01 AM by Sunil Agarwal | 7 Comments Filed under: Bulk Import/Export

• What are the Bulk Import Optimizations?

  Bulk 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 reduces Read More... Posted Monday, February 04, 2008 7:12 PM by Sunil Agarwal | 1 Comments Filed under: Bulk Import/Export

• Why Bulk Import?

  Most IT shops using SQL Server need to load/import large amount of data obtained from external sources or from another Database Server into SQL Sever. It is typcially done using the optimized insert path provided by SQL Server through Bulk Insert and Read More... Posted Monday, February 04, 2008 6:50 PM by Sunil Agarwal | 1 Comments Filed under: Bulk Import/Export