Many kudos to the author for:

a) posting the row size

b) posting the environment used

c) running equivalent tests

d) running the tests several times in a row

e) choosing a large enough data...

My two cents: Microsoft has a lot of conversions that happen throughout the year from Oracle to SQLServer. The transition for Oracle folks to get to SQLServer is made...

An interesting start, but the discussion doesn't go far enough. There needs to be a distinction: what is the target? Is the target OLTP systems? or is the...

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...

Hi Folks,

Lots of good comments here, but I want to make a couple things clear: I work with systems ranging in size from 1 Terabyte to...

Hi Folks,

I understand what is desired. Please don't get me wrong: set based processing has been around for a long long time. What is important here is to...

Hello,

While I agree with your approach - the basic concepts are sound - I disagree with one thing: processing the data on the way in to the data warehouse. ...