![[Video] Office Hours in Zhengzhou, China](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-e11585f81937-full-6e69cd24.webp)
Brent Ozar answers DBA questions on SQL Server, tempdb, AI, and career advice from Zhengzhou, China.
Explains why higher MaxDOP in SQL Server increases TempDB spills due to memory grant division across parallel threads.
![[Video] Office Hours: Long Answers Edition](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-a9f3e37652de-full-5d20e9da.webp)
Brent Ozar answers database questions on HADR_SYNC_COMMIT waits, indexing strategies, RCSI, and SQL Server comparisons.
Analyzes the current state and future of SQL Server's In-Memory OLTP technology, highlighting new features in SQL Server 2019 and persistent limitations.
Explores SQL Server's Memory-Optimized TempDB Metadata feature, which reduces contention by moving system tables into memory, with a performance test demonstration.
