Mastodawn

In this post I'm going over some large insert speed tests in SQL Server using various table types as targets, combinations of TABLOCK and MAXDOP 0, compression, and recovery models.
#sqlserver #dba #mssqlserver #mssql #sqlserverdba

https://vladdba.com/2023/06/22/testing-large-insert-speeds-in-sql-server

Testing large insert speeds in SQL Server

Testing large insert speeds in SQL Server using various table types as targets, combinations of TABLOCK and MAXDOP 0, compression, and recovery models.

VladDBA