Overview
Learn about SQL Server 2014's in-memory OLTP optimization technology in this 59-minute technical session. Explore memory-optimized tables and indexes, including both hash and non-clustered varieties, designed to enhance OLTP workload performance. Master accessing memory-optimized tables through interpreted Transact-SQL and optimize data operations using natively compiled stored procedures. Discover the advantages of lock-free transaction semantics in In-Memory OLTP and gain practical knowledge for implementing these features in database development work.
Syllabus
24 Hours of PASS: In Memory OLTP for Database Developers
Taught by
PASS Data Community Summit