A follow-up to my post on hash collisions: DMV queries that help with identifying InMemory OLTP Hash Collisions caused by a poorly chosen bucket count.
SQL Server – InMemory OLTP Hash Collisions Performance Overhead
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.