Migrating a Disk-Based Table to a Memory-Optimized Table in SQL Server

added by DotNetKicks
1/27/2017 2:04:46 PM

2 Kicks, 245 Views

The feature formerly known as Hekaton, now In-Memory OLTP can provide very useful performance gains where you carefully select the tables to become memory-optimised. How do you set about the job of converting existing tables to become memory-optimised tables? the process isn't entirely straightforward but the benefits that an In-Memory OLTP table delivers is worth your effort.