The worldwide data explosion is creating new challenges, and new opportunities for enterprises seeking to transform their business to better respond to ever changing market conditions. Businesses need better performance from their transactional applications to respond to customer demand in real time, not at the end of the day when the batch process completes. If they can’t meet the needs of their customers in real-time, they will lose to the competition. For example, customers that sell products online, are now looking to implement dynamic pricing so they can always offer their customers a competitive price.
In SQL Server 2008 R2, Microsoft shipped in-memory technology for BI and analytics on the server and in Excel with Power Pivot. In SQL 2012, an in-memory columnstore for data warehousing was added that improved query performance by up to 100x. These solutions helped customers get insights from their data much faster, and helped their employees make better decisions. With SQL Server 2014, the in-memory columnstore became updatable, and a new in-memory OLTP engine was shipped that delivers truly breakthrough transactional performance increases of, on average, 10x, and up to 30x.