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

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

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