Hi,
A good discussion topic I think.
I have been having these conversation with my superiors over the last 10 year.
I have discovered that no matter how much benefit this would give, it will always come second place to budget.
We have recently moved to the Amazon Cloud, lots or pros and definitely lots of cons, but now we have resource based costs.
All this means is that we work on the principle of " what is the least amount of resources we can work to".
In response to the topic, we have many small to medium size databases and our systems would be dramatically improved but loading completely into RAM but it just won't happen.
The alternative is to find alternative technologies that suit certain elements of our product, for example we are using Amazon Elastic search to store certain data thus reducing the number of calls to the main databases.
Rather than design to the capabilities of SQL Server and provide the resources (particularly RAM) to make it run well, I see in our products in particular a move to find cheaper "bolt on" solutions that solve immediate problems.
I'm not convinced
Give me more RAM

Graeme