Home > SQL Server 2016 > In-memory enhancements and improvements in SQL Server 2016

In-memory enhancements and improvements in SQL Server 2016


In-Memory tables were introduced in SQL Server 2014 and were also known as Hekaton tables. I’ve written previously about In-memory tables for SQL Server 2014 and you can check in my [previous posts] to know more about these type of tables with some Hands-on examples and demos.
 

–> In-memory tables as new concept in SQL Server 2014 had lot of limitations compared to normal tables. But with the new release of SQL Server 2016 some limitations are addressed and other features have been added for In-Memory tables. These improvements will enable scaling to larger databases and higher throughput in order to support bigger workloads. And compared to previous version of SQL Server it will be easier to migrate your applications to and leverage the benefits of In-Memory OLTP with SQL Server 2016.
 

–> I have collated all the major improvements here in the table below:

SQL Server 2016 - In Memory

* Collation Support
1. Non-BIN2 collations in index key columns
2. Non-Latin code pages for (var)char columns
3. Non-BIN2 collations for comparison and sorting in native modules
 

–> You can check more about In-Memory tables for SQL Server 2016 in MSDN BoL [here].
 

Check the above details explained in the video below:


  1. January 22, 2016 at 3:20 pm

    Great summary, thank you!
    Do you know if there are any changes with cross-database queries in 2016? For example, can a database that does not have a memory-optimized filegroup access a hekaton table in a memory-optimized database?

  1. January 5, 2017 at 12:05 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: