In-memory and hard-drive hybrid
Microsoft just announced Hekaton which allows you to have a mix of in-memory tables and traditional on-disk tables in the same database, and seemlessly integrate the two technologies.  It will ship in the next major release.  They annouced it at the 2012 SQLPass Summit during the day 1 keynote (viewable online).