Monday, December 10, 2018
Task Pane 
Remember Me
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?

[show results]
SQL Server 2014 In-Memory OLTP
Author: Darren Gosbell Date Posted: 1/15/2014 8:40:02 AM
SQL Server 2014 In-Memory OLTP (aka "Hekaton") is one of the most significant performance optimisations ever made to SQL Server's core OLTP database engine by Microsoft. In-Memory OLTP is a complete re-design of the database engine, promising speed improvements many times over the existing engine by elimination of storage i/o during query processing, removal of existing locking mechanisms & use of native code compilation (to .dlls rather than interpreted query plans).

Microsoft has integrated In-Memory OLTP directly into the core database engine, allowing tables & stored procedures to be simply converted as In-Memory OLTP objects and used normally. Limits apply to supported column types & TSQL language features in the initial SQL 2014 release however, so some planning is required prior to implementing In-Memory OLTP

In this presentation, Greg Linwood walks us through In-Memory OLTP demonstrating its core features and discussing how you can harness its power.

About Greg Linwood
Greg Linwood is a SQL Server performance tuning specialist and Managing Director of MyDBA - an international SQL Server support & consulting business. Greg has developer & DBA experience with SQL Server since 1993 and was the first Australian to receive Microsoft's SQL Server "Most Valuable Professional" (MVP) award in 2003. Greg is a founder of the Australian SQL Server User Group, founding the Melbourne SQL Server User Group in 2003.

Venue: Microsoft Level 5, Building 4, Freshwater Place, Southbank , Melbourne, VIC | Duration 5:30PM pizzas & drinks for 6:00 start, approx 7:45pm finish | On: Tuesday, January 21, 2014