A customer’s InMemory OLTP tables ran slowly because of a very low hash bucket count. Here is the hash collisions performance overhead and how to avoid it.
SQL SERVER – InMemory OLTP Migration Assistant Powershell Script
Is your application ready for In-Memory tables? A client upgrading from SQL Server 2005 asked me, so here is the InMemory OLTP Migration Assistant script.
SQL SERVER InMemory OLTP: Understanding Optimistic Multi-Version Concurrency Concepts
A reader asked what Optimistic Multi-Version Concurrency in InMemory OLTP really means. It sounds simple but is a loaded question, so here is a plain answer.
SQL SERVER 2016 – InMemory OLTP support for Foreign Key
SQL Server 2016 adds InMemory OLTP support for Foreign Key constraints, a big missing piece in SQL Server 2014. Here is how I tested it on CTP3.2.
SQL SERVER – Recompiling InMemory OLTP with SQL Server 2016
Can you recompile natively compiled InMemory stored procedures? I test recompiling InMemory OLTP objects in SQL Server 2016 with a step by step demo.
In-Memory OLTP in Azure SQL Database: Tiers, Limits and a Local Test
In-Memory OLTP in Azure SQL Database needs the right service tier and fits inside a memory cap. This post lists today’s tiers and limits from the documentation, then tests memory-optimized tables, a native procedure and a pre-scaling check on SQL Server 2025.
SQL SERVER – How to take InMemory – OLTP FileGroup Offline?
Can you take an InMemory OLTP filegroup offline, and what happens to the table data? I test it step by step using the database from my earlier post.