Category - Performance

SQL Server Performance

Miracle of OPTIMIZE_FOR_SEQUENTIAL_KEY

SQL Server 2019 provides another option to deal with the last-page insert contention – OPTIMIZE_FOR_SEQUENTIAL_KEY. It improves throughput for high-concurrency inserts into an...