Log records of update statement

Compared to insert and delete statement, the update statement creates more log records, even more than you expected. I’m going to use fn_dblog to show you HOW sql server create […]

DBCC Stackdump–new feature

Since SQL 2019 CU2, you can use DBCC Stackdump to create mini, filtered, full dump directly without using trace flag. Here are samples: DBCC STACKDUMP WITH MINI_DUMP DBCC STACKDUMP WITH […]