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.
2017-12-07
1,839 reads
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.
2014-11-11
220 reads
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.
2013-08-26
3,826 reads
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.
2012-10-02
3,322 reads
By Andy Warren
One of the things we’ve done most years in Orlando is to print poster...
By Steve Jones
I use Hyper-V and a few other things that require Windows 10 Pro. When...
By Devin-Knight
Welcome back to my series on Power Platform quick tips! In this episode you...
is there relation between Impact from sys.dm_db_missing_index_group_stats and Impact from cache plan? Thanks for...
I'm migrating DBs from a 2008 R2 instance onto a 2017 instance. I have...
Ask SSC