To ensure that memory is available for the In-Memory OLTP database and help avoid OOM (Out of Memory) conditions, the values for MAX_MEMORY_PERCENT and MIN_MEMORY_PERCENT should be the same. SQL ...

At the SQL PASS conference last November, we announced the In-memory OLTP (project code-named Hekaton) database technology built into the next release of SQL Server. Microsoft’s technical fellow Dave ...

New for SQL Server 2016 is the ability to place a Columnstore Index on an In-Memory Table.

SQL Server Integration Services Support for In-Memory OLTP [!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance] You can use a memory-optimized table, a view referencing memory-optimized ...

In a move to speed online transaction processing (OLTP), Microsoft is adding in-memory capabilities into its SQL Server relational database management system.

More details are emerging about in-memory capabilities and how they boost performance in the new SQL Server 2014, announced at the recent TechEd 2013 conference and possibly due for a CTP this month.

SQL Server, Memory Node object [!INCLUDE SQL Server] The Memory Node object in Microsoft [!INCLUDE ssNoVersion] provides counters to monitor server memory usage on NUMA nodes.

Everybody wants their databases to retrieve and store information faster, and with SQL Server 2014, which is released to manufacturing today, Microsoft is tweaking its columnar data store as well as ...