In-Memory OLTP and Isolation Levels in SQL Server (webcast recording)

One of the trickiest thing about in-memory tables in SQL Server is just figuring out how they work! Isolation levels are critical to master to make sure your code returns the right data. With memory optimized tables in SQL Server, you may use three different isolation levels: snapshot, read committed, and serializable. Follow along as I step through demos using these isolation levels with different types of transactions against in-memory tables. You'll learn how to configure your databases so you can stop typing so many hints, what each isolation gives you, and why you need to catch errors for special situations like uncommittable transactions. Scripts: https://gist.github.com/LitKnd/8195b58479f1c65c63913055155c7553 Transcript and links: https://sqlworkbooks.com/2017/12/in-memory-oltp-and-isolation-levels-in-sql-server-webcast-video/