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-12-30 (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.
2020-12-02 (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
When Covid took out the PASS organization, I had someone say to me, “Well,...
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I have a SSRS report for which users are complaining to be slow, but...
Hi I set this up today. I wanted to get some feedback. I have...
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint))
, BIT_COUNT (CAST (-1 as bigint))
See possible answers