Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features.

In-memory OLTP tables were introduced with SQL Server 2014. These tables keep the entire set of data in RAM, accessing the table contents from memory. This requires that all data fits into the ...

SQL Server 2014’s biggest new feature is in-memory transaction processing, or in-memory OLTP, which Microsoft claims can make database operations as much as 30 times faster.

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 ...

SQL Server 2016 is removing a lot of the limitations on memory-optimized tables including the inability to work with the large documents favored by NoSQL style designs.

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 ...

While temporal data support is something that has existed in the past within other database platforms, it is a newly available feature with the RTM version of SQL Server 2016. In case you haven't ...

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.

Microsoft's SQL Server 2014 has built-in in-memory technologies, so users don't need expensive additional software or hardware. Plus, it's fast.

The next version of Microsoft's SQL Server will allow users to host database tables, or even entire databases, within a server's memory.