With (Memory_Optimized = On; By default, setting the Memory_Optimized option creates a durable table. If you're willing to lose all of your data when SQL Server shuts down you can add a Durability ...

SQL Server has long had a function called table pinning, which allowed certain tables to not be flushed from memory once they are read. This feature has been misconstrued in the past as a kind of ...

One of the most important differentiators amongst SQL Server 2014 and its earlier counterparts is in the former’s support for in-memory database tables. When our computer systems go slow we ...

This whitepaper illustrates the SQL Server 2016 business intelligence/data warehouse upgrades, the memory-optimized tables, and the columnstore indexes. We also discuss the performance comparison of ...

Memory Optimized Tables promise significant performance gains, but tend to be difficult to work with. SQL Server 2016 reduces much of the pain by offering ALTER TABLE support.

In SQL Server 2014, Microsoft is introducing the In-Memory OLTP database engine which essentially performs the entire I/O operation set against selected tables straight from memory.

New for SQL Server 2016 is the ability to place a Columnstore Index on a Memory Optimized Table. To understand what that means, we should first define the terms Columnstore Index and Memory ...

The CTP2 release of SQL Server 2014 is a test release or "evaluation edition" that will expire on March 31, 2014 and can be downloaded here. However, Clark described it in his announcement as "our ...

SQL Server 2016 CTP 3.1 features improvements to in-memory OLTP such as unique indexes in memory-optimized tables, building upon support for unique constraints in CTP 3, released in October. Related ...