Blog - Title

February, 2008

  • SQL Server Storage Engine

    Bulk Import Optimizations (Minimal Logging)

    • 13 Comments
    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...
  • SQL Server Storage Engine

    Why Bulk Import?

    • 1 Comments
    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...
  • SQL Server Storage Engine

    What are the Bulk Import Optimizations?

    • 1 Comments
    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...
Page 1 of 1 (3 items)