A few episodes ago, I talked about how learning about Write Ahead Logging was a light bulb moment for me, and helped me learn tons of concepts about backups and recovery. This week, we talk about when SQL Server turns things upside down and doesn’t use write ahead logging: and what it has to do for recovery in these special cases.
Links and references
Download Kalen Delaney’s In-Memory OLTP Whitepaper for 2016: http://sqlblog.com/blogs/kalen_delaney/archive/2016/07/12/sql-server-2016-rtm-in-memory-oltp-whitepaper.aspx.
- The 2016 version of Kalen’s In-Memory book with Redgate is coming soon!
Erin Stellato did a demo of performance testing if In-Memory benefits a given table in the SQLSkills Insider Newsletter #149
- Join the Insider newsletter to get future demos: https://www.sqlskills.com/join-the-sqlskills-insider-community
- Download Erin’s video from SQLSkills here (wvm) or in mov format
- Download Erin’s code samples from SQLSkills here (zip)