November 2013

In-Memory OLTP and the Identity Column

Over the past month I’ve been playing around with the new In-Memory OLTP (code name: “Hekaton”) features within SQL Server 2014 CTP2. My organization is all about low latency applications, and this is one feature of SQL Server that I need to get familiar with ASAP. To do this, I started my own little project that takes an existing database and converts parts of it into in-memory tables.  Once that step is complete, I could work on rewriting the TSQL code. It might seem fairly simple, but with every new feature of SQL Server there are usually limitations. And one...

Continue reading...