The next version of SQL Server due to release in 2014/2015 is code named hekaton. Hekaton in greek means hundreds and is expected to speed up database performance by 30X times without code changes to existing applications or hardware.
Hekaton stores most frequently accessed tables in Memory. A new tool which is being in-built within SQL Server will help identify tables that are most frequently accessed.
This is similar to the concept in PowerPivot, x-Velocity, Tabular models in BISM where everything is stored in memory.
The other performance enhancer is Bwtree, which is latch based.
Bwin (largest regulated online trading company) one of our esteemed clients increased its through put 10 times when in trial runs.