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.
2019-04-10 (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-03-13 (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
By Steve Bolton …………In the last two installments of this series of amateur self-tutorials...
This year PASS is trying something new at PASS Summit. There are going to...
One of the most significant and hardest challenges we face as data professionals (or...
I have a table "Mytable" containing a list of IDs. There is a web...
So I have a DW with a table with some pre-aggregated scores (not my...
HI all, About to start this project and would be grateful for any good...
Ask SSC