When SQL Server® 2014 brought in some interesting innovations around In-Memory objects it was one of a kind in the industry. It was amazing to see how In-Memory objects can be ACID complaint, persistent, and not be lost because of power outages. I have yet to see users using this feature to its full potential […]
Read More
SQL Server 2014’s new In-Memory OLTP feature can potentially revolutionize your OLTP workloads by providing big performance increases with little or no changes to your servers or application code. Microsoft’s In-Memory OLTP delivers performance improvements of 2x to 30x depending on the application. As a brief reminder, SQL server 2014’s In-Memory OLTP works by memory-optimizing […]
Read More
There’s no doubt that the most important new feature that Microsoft added to SQL Server 2014 is the new In-Memory OLTP engine. The In-Memory OLTP engine enables you to move select tables and stored procedures into memory for high-performance, low-latency data access. With CPU processing speeds plateauing and memory capacities expanding, Microsoft turned to utilizing RAM […]
Read More
SQL Server 2014 introduced the new database engine enhancement called In-Memory OLTP. This feature uses new data structures which are optimized for in-memory access of table. People normally call it In-Memory database. In reality, we would like to call it partially in-memory database because SQL Server allows us to have few hot tables in-memory and […]
Read More
SQL Server and database experts share insights on features of SQL Server 2014 that promise significant performance potential.
Read More