Archive for June, 2013
Now that SQL Server 2014 CTP1 is available many of us will be playing with the Hekaton functionality. To understand what is going on under the covers here is a very good internals presentation given by Sunil Agarwal at the recent TechEd North America 2013:
In this link Sunil explains filestream data files (each 128Mb in size), delta files, merging of delta files, offline checkpoint process, minimal transaction log writes, new fn_dblog_xtp function plus much, much more.
Sunil presented two other Hekaton sessions at the same conference: