In-Memory OLTP (Hekaton)

Remember “Nothing Stops a Hekaton Transaction?” Yeah, About That.

Last Updated July 29, 2020

When In-Memory OLTP first came out, Microsoft liked to go around bragging at conferences that “Nothing stops a Hekaton transaction.” I remember hearing that and kinda chuckling at the time, and I was reminded of it by a recent client who was running into blocking issues with…yep, Hekaton. To reproduce it: Do a large insert…

Initial Thoughts on 2016 SP1

Last Updated February 13, 2017

Erik Darling

In-Memory OLTP (Hekaton), Licensing, Partitioning, SQL Server

A really odd choice I’ve talked a bit about my annoyance with hardware limits for Standard Edition here and here. If you’re a bunch of SQL-savvy developers who understand the Enterprise Edition features that are now available in 2016 SP1, great. You’re a very small minority of shops. I’m talking about places like StackOverflow and…

SQL Server 2016 Standard Edition Now Has Many Enterprise Edition Features.

Last Updated February 13, 2017

Brent Ozar

In-Memory OLTP (Hekaton), Licensing, SQL Server

Starting with today’s release of SQL Server 2016 Service Pack 1, Standard Edition now has a lot more of the features of Enterprise Edition. Here’s the list from Microsoft’s announcement post: Performance features – in-memory OLTP (Hekaton), in-memory columnstore, operational analytics Data warehousing features – partitioning, compression, CDC, database snapshots Some security features – Always Encrypted,…

RAM and Sympathy

Last Updated February 13, 2017

Erik Darling

In-Memory OLTP (Hekaton), Licensing, SQL Server

With the release date for 2016 finally announced Everyone can start gearing up to gaze upon its far shores from the 2008R2 instance they can’t or won’t upgrade for various reasons. I’m excited for a lot of the improvements and enhancements coming along, and generally hope I’m wrong about customer adoption. One annoyance with the…

How to Run DBCC CHECKDB for In-Memory OLTP (Hekaton) Tables

Last Updated February 15, 2019

Brent Ozar

CHECKDB and Corruption, In-Memory OLTP (Hekaton), SQL Server

tl;dr – run a copy-only full backup of the Hekaton filegroup to nul. If the backup fails, you have corruption, and you need to immediately make plans to either export all your data, or do a restore from your last good full backup, plus all your transaction log backups since. Yeah, that one’s gonna need a…

The @DBAreactions Guide to In-Memory OLTP (Hekaton)

Last Updated February 13, 2017

Brent Ozar

In-Memory OLTP (Hekaton), SQL Server

At SQLbits last month, I presented a new session: Cool Story, Bro – The DBAreactions Guide to SQL Server 2014. I wanted to have some fun while educating folks about the surprise gotchas of the newest features. Here’s the In-Memory OLTP (Hekaton) section of the session: Our sp_Blitz® has long warned you if Hekaton is in…

Announcing sp_Blitz v36: New Database Checks, Hekaton, Azure Files, More

Last Updated February 13, 2017

Brent Ozar

In-Memory OLTP (Hekaton), SQL Server

The latest version of our free SQL Server health check adds some nifty new stuff: Checks for non-default database configurations like enabling forced parameterization or delayed durability Looks in the default trace for long file growths or serious errors like memory dumps Checks Hekaton memory use and transaction errors Warns about database files on network…

Are Table Variables as Good as Temporary Tables in SQL 2014?

Last Updated February 13, 2017

Kendra Little

In-Memory OLTP (Hekaton), SQL Server, TempDB

There’s a couple of new features in SQL Server 2014 that provide options for how you work with temporary objects. Will inline index creation or memory optimized temporary tables forever change the way you code? Let’s take a look! Inline Index Creation SQL Server 2014 brings us a TSQL improvement called “inline specification of CLUSTERED…

#SQLPASS #Summit2013 Professor DeWitt Keynote

Last Updated August 11, 2019

Brent Ozar

#SQLPass, In-Memory OLTP (Hekaton), SQL Server

This morning at the PASS Summit, we have the pleasure of listening to Professor David DeWitt talk about Hekaton internals. I’m actually not going to liveblog this – I’m going to sit back and take in the presentation as an attendee because it’s going to be so damn good, and I’m not going to be…