THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Kalen Delaney

Geek City: SQL Server 2014 In-Memory OLTP (“Hekaton”) Whitepaper for CTP2

Last week at the PASS Summit in Charlotte, NC, the update of my whitepaper for CTP2 was released.

The manager supervising the paper at Microsoft told me that David DeWitt himself said some very nice things about the technical quality of the paper, which was one of the most ego enhancing compliments I have ever gotten! Unfortunately, Dr. DeWitt said those things at his “After-the-keynote” session, not in the keynote that was recorded, so I only have my manager’s word for it. But I’ll take what I can get.

If you’d like to read the update, which has information about the new “range” indexes, natively compiled procedures, checkpoint files, recovery and garbage collection in addition to all the content from the CTP1 paper, you can get it here:


There will be more enhancements made for RTM, including some graphics for the index maintenance operations on range indexes, plus best practice suggestions.  These enhancements may be in the form of a third paper, but they might be in book form. I’ll let you know!



Published Sunday, October 20, 2013 6:05 PM by Kalen Delaney

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Jungsun Kim said:

Thanks, Kalen.

October 22, 2013 12:52 AM

Greg O'Connell said:

Great white paper. Would be even greater if the recurring phrase "different than", was replaced by "different from".

October 28, 2013 5:42 AM

Kalen Delaney said:

Hi Greg, thanks for the feedback.

I'm sorry you don't like "different than", but it is just personal preference, you know.

Thanks again


October 28, 2013 7:01 AM

Mladen Andrijasevic said:

Questions on Hekaton and RCSI

Page 22

Isolation level READ_COMMITTED_SNAPSHOT is supported for memory-optimized tables with autocommit transactions and only if the query does not access any disk-based tables.

Page 30  

Table 1 Compatible isolation levels in cross-container transactions   -- there is no mention of RCSI

So, it seems Interop cannot use RCSI. Is that correct?  

We have the RCSI bit in our database. What do we for Interop queries?   Do they have to be changed to READ COMMITTED or   REPEATABLE READ  / SERIALIZABLE

How do we use  READ COMMITTED if the RCSI bit is on?


October 28, 2013 8:37 AM

Kalen Delaney said:


There is an email address at the end of the whitepaper to send questions to. If you send your questions there, I can track them much more easily than I can track comments on my blog. I can also mark them for followup, etc and make sure I eventually get back to you on this.



October 28, 2013 2:11 PM

Mladen Andrijasevic said:

Hi Kalen,

I sent my question to

under the subject

White paper Feedback:Hekaton Internals

approximately at the same time I posted my question on your blog, but so far did not get any confirmation that the email has been received. Could you please confirm that the email reached its destination.



October 29, 2013 4:35 AM

Kalen Delaney said:

Thanks Mladen. I don't always check that alias when I'm travelling, but I'll try to verify the mail today.


October 29, 2013 7:33 AM

Kalen Delaney said:

Hi Mladen

The alias stands for HeKaton WhitePaper, but whoever edited the paper entered it wrong. It should be hkwp instead of hkwb.  But, since this wrong address is now part of the paper, I have set up a forwarder that mail sent to hkwb now will be redirected to hkwp.

If possible, could you please resend.



October 29, 2013 2:06 PM

Mladen Andrijasevic said:


October 30, 2013 11:18 AM

Louis Davidson said:

This part is part of an ongoing series of blogs I am writing while preparing to give a presentation based

July 6, 2014 4:15 PM

Anonnymouse said:

For Greg (and other pedants)

Knock knock.

"Who's there?"


"To who?"

"I think you mean To Whom ..."

(Courtesy of Matt Lucas)

October 21, 2015 7:57 AM

André said:

Hi Kalen,

how are you?

I have a question about query interop in sql server 2016 in-memory.

How do you interprets the queryq's?

November 9, 2016 1:54 PM

André said:

Hi Kalen,

how are you?

I have a question about query interop in sql server 2016 in-memory.

How do you interprets the queryq's?

November 9, 2016 1:54 PM

aaaa said:

mt0417 mt0417

April 16, 2018 8:41 PM

shenyuhang said:


June 1, 2018 7:04 PM

kanker paru paru bisa sembuh tanpa operasi said:

June 28, 2018 6:38 PM

kesehatan said:

July 4, 2018 9:56 PM

kesehatan said:

July 6, 2018 9:03 PM

kesehatan said:

July 9, 2018 12:42 AM

obat kanker payudara terbaik said:

July 10, 2018 8:50 PM

obat meningkatkan kecerdasan otak said:

July 13, 2018 9:43 PM

obat keputihan berlebihan dan berbau said:

July 15, 2018 8:50 PM

linying123 said:



July 16, 2018 8:32 PM

dongdong8 said:



July 23, 2018 11:29 PM

shenyuhang said:


July 23, 2018 11:35 PM

obat diabetes said:

August 1, 2018 11:17 PM

obat bronkitis anak secara alami said:

August 7, 2018 7:49 PM

obat sinusitis said:

August 10, 2018 7:22 PM

yaoxuemei said:


August 15, 2018 2:04 AM

qqq said:

August 15, 2018 11:58 PM

masker wajah alami untuk menghilangkan jerawat said: Masker wajah alami untuk menghilangkan jerawat Obat liver alami aman dan terbaik Obat herbal sinusitis kronis terbaik Obat bronkitis anak secara alami Obat Kanker Payudara terbaru 2018 Cara meningkatkan nafsu makan secara alami Obat herbal diabetes menurunkan gula darah Obat herbal kusta terbaik Obat benjolan di leher tanpa operasi Obat Herbal Kanker Otak tuntas hingga akar Obat TBC alami aman tanpa efek samping Obat radang amandel sembuh tanpa operasi Obat asam urat alami tanpa efek sampinfg Obat tetes Sariawan secara alami Cara mengobati mata bengkak dengan cepat Obat tradisional kanker lambung terbaik Obat kanker paru paru Obat usus buntu alami tanpa operasi Obat asam lambung naik cara alami

August 20, 2018 8:59 PM

chenjinyan said:


August 22, 2018 11:04 PM

shenyuhang said:


August 23, 2018 10:15 PM

obat herbal koresterol terbaik said:

August 23, 2018 10:57 PM

obat usus buntu alami tanpa operasi said:

August 24, 2018 12:21 AM

obat benjolan di tubuh said:

August 30, 2018 7:40 PM

obat wasir said:

September 4, 2018 8:26 PM

obat katarak said:

September 16, 2018 5:46 PM

obat maag said:

September 17, 2018 7:10 PM

obat limfoma said:


September 23, 2018 6:50 PM

kakakaoo said:

October 8, 2018 2:32 AM

kakakaoo said:">


November 8, 2018 2:10 AM

qqq said:


March 27, 2019 12:58 AM

Leave a Comment


This Blog


Favorite Non-technical Sites or Blogs

Privacy Statement