In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.
2020-01-15 (first published: 2015-05-13)
55,467 reads
In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.
2019-12-18 (first published: 2014-03-05)
80,501 reads
Download your free copy of SQL Server Transaction Log Management and see why understanding how log files work can make all the difference in a crisis.
2013-06-27
5,550 reads
Query tuning is not easy. In fact, for a lot of people, you shouldn’t...
This year I’ve been nominated again for the Author of the Year award at...
I know, I know, I’m on #teamexevents so I think that Extended Events can...
problem how to create query based on optional field on temp table ? I...
problem how to create query based on optional field on temp table ? I...
I want to create a transaction replication (SVR-A to SVR-B) from scratch on one...
Ask SSC