I'm looking forward to a different tuning paradigm that does not have to take Disk IO into account (as much).
I'm fairly convinced on these right now before actually using one.
They have addressed all of my concerns thus far.
But, I would like to know more about what the next bottleneck would be so I can design servers around that too.
Will it be machine related or software? Can SQL Server even handle the parrallel processing required to get the most out of IO this fast?
My intent is to put the entire data warehouse database on one of these.
What would happen then?
I know 64bit would really help.
I know faster and more processors is always great.
But what about getting that data into memory.
How fast would that be?
How many processors could it use on a single column update on 300,000,000 rows?
These are just some of my thoughts and questions.
I do not expect complete answers to these question until I actually get one and do it.
But any direction is very much appreciated.