Take a look at this great whitepaper recently published that discusses common patterns for implementing and leveraging the new In-memory OLTP capabilities of SQL Server 2014.

Download the whitepaper from: http://msdn.microsoft.com/en-us/library/dn673538.aspx

In-Memory OLTP allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures. For performance critical workloads, users can also migrate Transact-SQL code to natively compiled stored procedures. This can provide additional performance gains. This paper aims to help readers understand some of the common architectural patterns where In-Memory OLTP has provided significant benefits. The paper also discusses considerations for migrating applications to In-Memory OLTP.