You’ve probably heard of the SQL Server project Hekaton. It’s an in-memory solution for data, introduced in SQL server 2014. One cool feature besides the durable in-memory tables, is the possibility to create non-durable in-memory tables. As you realize, you can get a lot of performance improvement with the in-memory solution, but what is the benefit with non-durable tables as the data will be lost in case of failure? Well, one option is to use non-durable in-memory tables as staging tables in your ETL solution as you don’t care about the staging data in case of a system crash.
Read more about SQL Server 2014 at: http://www.microsoft.com/en-us/sqlserver/sql-server-2014.aspx