Microsoft SQL Server 2014: In-Memory OLTP for Database Developers
Play Microsoft SQL Server 2014: In-Memory OLTP for Database Developers
SQL Server 2014 introduces in-memory technology for optimizing OLTP workloads. In this session we focus on the new concepts for database developers. We discuss the new memory-optimized tables and the new memory-optimized hash and nonclustered indexes. You also learn how to access memory-optimized tables using interpreted Transact-SQL, and how to optimize data access using the new natively compiled stored procedures. Finally, learn how to work with the new lock-free transaction semantics for in-memory OLTP.