Hi Jeff,

I'm sorry if I wasn't clear enough. 400k rps is where SQLServer 2008 R2 should be going - it's not where it is today. 400k rps during load is only achieved in Teradata with a Teradata hardware setup using FastLoad. I've also achieved this inside of Teradata when transferring data from one table to another: select from insert into... statements.

I would love to see SQLServer 2008 R2 get there, but the fastest I've seen SQLServer 2008 R2 run is 120k rows per second using Informatica 8.6.1 on 32 bit Windows Server 2008, with SQLServer 32 bit 2008 R2 using internal Ultra-SCSI disk, raid 0+1 array config. Informatica on the same machine as SQLServer, reading from internal disk, writing back to internal disk. Dell PowerEdge 2650 with 4GB RAM.

Hope this helps clear things up... Again, the nature of competition and the drive for performance is really what this is all about - and from a business perspective, moving data into a data warehouse requires adaptability of IT (agility to respond), and performance of the hardware. So at the end of the day, removing the business rules from the raw EDW becomes a necessity in volume situations.

Hope this helps,

Dan Linstedt

PS: Sales Pitch: I'm available for consulting, I've been consulting on systems architecture & design, performance analysis and tuning of large scale systems for years.