How the CHECKPOINT process deals with uncommitted transactions
At the beginning of my SQL Server Performance Tuning Workshop I always start by giving a general overview of what happens within SQL Server when we execute a query. Executing a SELECT query is quite simple, but executing a DML statement is more complex, because SQL Server has to change the corresponding page in memory, …
How the CHECKPOINT process deals with uncommitted transactions + read more
