Tempdb Articles

Page 1 of 1 (3 articles)

7/23/2026 • EN

[Video] Office Hours: Long Answers Edition

Brent Ozar answers database questions on HADR_SYNC_COMMIT waits, indexing strategies, RCSI, and SQL Server comparisons.

Database Administration indexing Query Performance SQL Server Tempdb

Brent Ozar

11/4/2019 • EN

In-Memory, Quo Vadis ?

Analyzes the current state and future of SQL Server's In-Memory OLTP technology, highlighting new features in SQL Server 2019 and persistent limitations.

Database Optimization In Memory Oltp Memory Optimized Metadata SQL Server Tempdb

Niko Neugebauer

10/30/2019 • EN

Memory-Optimized TempDB Metadata

Explores SQL Server's Memory-Optimized TempDB Metadata feature, which reduces contention by moving system tables into memory, with a performance test demonstration.

Database Optimization In Memory Metadata Contention SQL Server Tempdb

Niko Neugebauer

Tempdb Articles

[Video] Office Hours: Long Answers Edition

In-Memory, Quo Vadis ?

Memory-Optimized TempDB Metadata

Select Language

We use cookies