Today’s goal is to understand what is the Last Page Insert PAGELATCH_EX Contention Due to Primary Key. Let us start understanding it together.
Recovery Model Insert Test: FULL vs SIMPLE Under Load
A recovery model insert test compares FULL and SIMPLE under a load of 16 connections. The log written is almost the same in both, and the elapsed time depends more on the server than on the model. The real difference is when the log can be reused, and this post shows that step by step.
How to Get Details of All Files Associated with Database from MDF? – Interview Question of the Week #275
Question: How to Get Details of All files Associated with Database from MDF? Let us learn about the DBCC command DBCC command dbcc checkprimaryfile.
Insert Workload Waits: WRITELOG and PAGELATCH_EX
Insert workload waits come down to two names, WRITELOG and PAGELATCH_EX. This post runs 16 connections that insert one row at a time and reads their waits with a tested script. It explains what each wait means and where to look for a fix.
Writing Rerunnable Deployment Scripts for Database Changes
Write rerunnable deployment scripts with guarded schema changes, version records, and a dry run on a restored database copy.
SQL SERVER Management Studio and SQLCMD Mode
Honestly, there is an alternative way to quickly use SSMS SQLCMD mode as a development environment, let us learn about it today.
sqlcmd vs SSMS: How to Time the Same Loop Fairly
A sqlcmd vs SSMS timing is fair only when both tools run the same file. The clock must sit inside the script. This post times 10,000 inserts three ways with a log table, shows what changed and what didn’t, and lists the settings to match before you compare.