Today we will see an interesting story about Memory Optimized Tables, Transactions, Isolation Level and Error. Let us read the blog post.
There are many reasons to envy my job as SQL Server Performance Tuning Expert Consultant but the most important reason is that I get to work on quite often the latest version of SQL Server. Just the other day I had an early adopter customer who was using SQL Server 2019 for their environment and they wanted me to help them with the new feature of Accelerated Database Recovery.
Question: How to Update Two Tables in One Statement?