There was a lot of response on the ETL performance test that was published last week so I have published the source code for all the tests at the below link.
Happy testing, also please feel free to share any interesting finds. I have highlighted the first DFT to show the impact of not pre sizing the database files when performing ETL.
30 min ETL brought down to 1 min just by preventing auto growth.
Database backup File
Actual data (BIG FILE)
Please Consider Subscribing