GilaMonster (4/1/2014)
In-memory OLTP (hekaton) is for heavy concurrent load (tens of thousands of concurrent connections with thousands of inserts/sec). The advantage is the lock-less, latch-less optimistic concurrency. It's not a silver bullet for performance in all circumstances.
I'm curious. Why wouldn't it run as fast as a normal table that's been cached?
--Jeff Moden
Change is inevitable... Change for the better is not.