Application integration & Middleware Memory management, OOM issues with SQL Server 2014 In-memory OLTP 22.01.2015 by Microsoft Team Last week I gave a workshop about SQL Server 2014 and the new features. The first day we worked on new In-memory OLTP and different topics such as the new internal storage, the new transaction processing behavior or the(…)
Database management SQL Server 2014: In-Memory tables, Bw-Tree, and storage 17.04.2014 by Microsoft Team SQL Server 2014 introduces hash indexes with in-memory optimized tables. I described some of their aspects in a previous blog post. These indexes are very efficient with lookup search operations but have some limitations with operations(…)
Database management SQL Server 2014: Deleting files of a hekaton table 06.03.2014 by Microsoft Team A recurrent question I have often heard about Hekaton objects is the following: Is an accidental deletion of the compilation files of a hekaton table on the file system irreversible and could this compromise the execution of SQL Server?(…)
Application integration & Middleware SQL Server 2014: Hekaton memory optimized tables, hash indexes, and bucket counts 14.02.2014 by Microsoft Team For my first blog post at dbi services, I think it could be a good opportunity to begin by discussing around SQL Server 2014, Hekaton memory optimized tables, and hash indexes. When you create a memory optimized table you(…)