Roger Walter from the SQL team has written about the In Memory Database that Microsoft where developing and the challenges that were faced. Whilst it covers IMDB it also covers why SQL Server is better in a lot of situations when used as a cache.
Read Rogers post here Whither IMDB?
Cross posted from http://sqlblogcasts.com/blogs/simons