SQL Server 2014 delivers breakthrough mission critical performance with in-memory capabilities built-in and backed by customer, partner and industry-leading benchmarks.
The new SQL Server 2014 In-Memory OLTP with the memory-optimized columnstore feature deliver breakthrough performance gains for both OLTP applications and data warehouse queries. SQL Server 2014 is the first mainstream RDBMS to integrate both in-memory OLTP and a memory optimized columnar data storage capability into the relational database engine.
To gauge the benefits of in-memory technologies, Microsoft engineers measured a collection of complex data warehousing queries running with and without columnstore indexes on a large data warehouse.
Using a combination of compression, algorithms optimized for modern CPU/memory architectures, and highly parallel execution, xVelocity can speed up query execution times by 4x, 10x, and even 100x, simply by adding columnstore indexes to the fact tables of a star-schema data warehouse.