Demo scripts for my talk "Bulk load: methods for better data warehouse load performance"
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
000_DatabaseSetup
010_HowToBulkLoad
020_MinimalLogged
030_Indexes
Bulk Load Demo.ssmssln
LICENSE
README.md

README.md

Bulk load: methods for better data warehouse load performance

Demo scripts for my talk "Bulk load: methods for better data warehouse load performance"

When loading a data warehouse you want the data inserted into the tables as fast as possible. You know you have to use bulk loading, but what do you need to do to ensure a minimal footprint on the transaction log? In this session, you will learn about minimal logged operations. You will also learn about the different methods for bulk loading data into your data warehouse; using SSIS, BCP and T-SQL.

Slides can be found at:

https://speakerdeck.com/dphansen/bulk-load-methods-for-better-data-warehouse-load-performance