SQL developers who want to create much faster databases.
The SQL Server 2014 and 2016 Hekaton project brings us In-Memory tables and Natively Compiled T-SQL objects that run at amazing speed. What you can accomplish is astounding. This presentation will introduce you to the Hekaton technology and show how big the differences can be and where you can put it to best use starting right now.
We’ll start with a review of In-Memory tables and how they work and how they achieve the ACID properties. Then we’ll show how Natively Compiled T-SQL works with in-memory tables. How transaction-handling is different and then go over some of the limitations of the T-SQL in natively compiled code. Various uses cases will be demonstrated with code and benchmarks that will give you ideas for adding In-Memory tables and Natively Compiled T-SQL your SQL databases.
Why I Want to Present This Session:
I’ve been working on putting this to work in practice on a large system and I’m really excited about the size of the performance changes.