Memory-Optimized tables in SQL Server 2016 and Azure

Storing and accessing data in memory is an order or magnitude faster than storing it on disk. With this in mind, implementing in-memory databases is a recipe for much faster database operations, be it queries or data updating.

SQL Server's latest version support memory-optimized tables, and as either as a database administrator or application developer, it's important to know what the options (and limitations) are. Microsoft has written a good overview of everything that's available on these tables here, so I suggest taking a look.

Happy hacking!