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

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

First introduced in SQL Server 2012, columnstore indexes can give you major performance gains -- provided you have the right workloads. Here's how columnstore indexes work and what types of data ...

And that's where SQL Server's In-Memory OLTP (online transaction processing) tables come in. In memory OLTP tables (I'll just call them memory-optimized tables from here on) were introduced in SQL ...

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.

More details are emerging about in-memory capabilities in the new SQL Server 2014, announced at the recent TechEd 2013 conference. The first Community Technology Preview is expected to be released ...