Love the topic and interesting points.

Yes I agree with others here that if you have an older server in memory databases would not be good, however if you added SSD drives for just tempdb you would experience a performance increase by at least 200%.

Back in the days of SQL 7.0 I was playing with a 3rd party tool that created a RAM drive in memory on Windows NT4.0 (yes this is old stuff) and I moved the tempdb in this RAM drive. The increase in performance was outstanding, averaging 200-400%. Now jump to today. We can easily get a servers with over 100Gigs of RAM and could allocate a slice for a RAM drive. Then we could run a script to move tempdb to this RAM drive every time SQL server starts. Only problem, there is not RAM disk software for Windows 2008.

Simple yet effective way to get a large performance boost.

Yes, I know, I too have old SQL servers here and this technology will not help them. But any new servers (64 BIT) would be able to take advantage of this setup.

Just my thoughts,

Rudy