In this book, Kalen Delaney explains how the 2016 In-Memory OLTP engine works, how it stores and manipulates data, and how, even with all data stored in memory and no locking or latching, it can still guarantee the ACID properties of all transactions.
In this book, Kalen Delaney explains how the 2016 In-Memory OLTP engine works, how it stores and manipulates data, and how, even with all data stored in memory and no locking or latching, it can still guarantee the ACID properties of all transactions.
Your application can have impeachable indexes and queries, but they won’t help you if you can’t get to your data because another application has it locked. That’s why every DBA and developer must understand SQL Server concurrency and how to troubleshoot excessive blocking or deadlocking. Kalen Delaney’s book is your guide.
Your application can have impeachable indexes and queries, but they won’t help you if you can’t get to your data because another application has it locked. That’s why every DBA and developer must understand SQL Server concurrency and how to troubleshoot excessive blocking or deadlocking. Kalen Delaney’s book is your guide.
FIRST OF A TWO PART SERIES Some months ago, a fellow DBA came to...
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
By SQLPals
Suppose you want to or need to know anytime your SQL Server is experiencing...
Comments posted to this topic are about the item Protecting Data Between Services
We have several new servers running SQL 2014. Some servers are single instance servers...
I’ve recently been having an issue with ssms freezing and crashing while editing a...
Ask SSC