ebook

sql-server-in-memory-oltp book cover

Free eBook: SQL Server Internals: In-Memory OLTP

  • Article

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: )

55,467 reads

External Article

Free eBook: SQL Server Backup and Restore

  • Article

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: )

80,501 reads

Blogs

Truncating very large transaction log in full recovery mode

By

While I always configure transaction log backups for every database in non-simple recovery model,...

Autonomous Driving Around London

By

There’s a video of Bill Gates taking a drive in an autonomous car around...

Best way to monitor high worker thread on SQL Server

By

It is common to see high worker count issue on the production server and...

Read the latest Blogs

Forums

Is TemporalTable SysStartTime available before performing an insert/Update?

By Dwaine Wright

I want to align a Date column (datetime2(7)) with the same full resolution date...

multiple PAGELATCH_UP waits on data file

By bobrooney.81

Hi Experts, What is meant by PAGELATCH_UP waittype ? what does it trying to...

dynamic update to SP

By Bruin

Looking for suggestions\examples of how to update a SP that the table used changes...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers