Useful SQL Server 2019 features 1. Memory-optimized TempDB metadata. In SQL Server 2019 Microsoft introduces a new feature that is part of the In-Memory Database feature family. This is memory-optimized TempDB metadata. Now the system tables involved in managing temporary table metadata can be moved into latch-free non-durable memory-optimized tables. Use the following script to turn on the memory-optimized TempDB…
This content is for Pro, Pro Member, Pro Member Annual – Fall Sale, Pro Member Monthly – Fall Sale, Standard, Standard Member, Standard Member Annual – Fall Sale, and Standard Member Monthly – Fall Sale members only.
Register
Register
Already a member? Log in here