The next wave in BI
Interesting TDWI post
The latest post on the TDWI site by Stephen Swoyer about bulk load performance contains several paragraphs written by Jos van Dongen based on his TPC-H SF100 load experiments. Please beware that there is one misquote in the article: Steve writes that OS DB's cannot load faster than 20-30 GB/Hr. This is not an absolute number and only correct considering the hardware mentioned. You can probably load > 100GB with a bunch of fast SSD or SAS disks in Raid 0 or 10 but it's beyond our budget to try out.