Query percentage complete is not a column in any view, but sys.dm_exec_query_profiles reports how many rows each operator has produced against the plan’s estimate. This post builds a monitor query for a running statement, explains why a percentage can pass 100 or even run into the thousands, and shows which operators to trust.
Compute Scalar Operators: Why a Computed Column Shows Two
A plan that reads a computed column shows two Compute Scalar operators, and the second one looks like a mistake. This post compares three tables in the plan text: an expression in the query, a computed column and a persisted computed column. It shows what each of the Compute Scalar operators defines and whether the extra operator costs anything.
WITH NORECOMPUTE: Stop Auto Updates on One Table
WITH NORECOMPUTE tells SQL Server to stop updating the statistics of one table automatically. This post sets it with UPDATE STATISTICS, proves that the modification counter keeps growing while nothing refreshes, and shows how to turn it off again. It also shows a safer option for the same problem, a persisted sample percent.
Deadlock Victim Selection: Protect One Transaction
Deadlock victim selection decides which of two blocked transactions SQL Server rolls back. This post shows the rules, sets DEADLOCK_PRIORITY on one procedure, reproduces a deadlock with two query windows, and shows what the setting cannot do. It ends with the two fixes that remove the deadlock itself.
Execution Plan Wait Stats: Read Them in SSMS and XML
Execution plan wait stats list what one execution of a query waited for, so you don’t have to guess from server-wide totals. This post shows where to find them in SSMS and in the plan XML, reproduces a lock wait with two query windows, and explains the common wait types. It ends with Query Store, which keeps wait totals for many queries.
Multiple Aggregates in One Query: Read the Table Once
Multiple aggregates in one query read a table once, where separate subqueries read it again and again. This post measures the logical reads of two subqueries against one SELECT, uses CASE inside SUM for different filters, and shows two cases where the rewrite gains nothing or loses to an index.
LPIM Memory Model: Check It With sys.dm_os_sys_info
The LPIM memory model tells you whether SQL Server runs with locked pages. This post reads it from sys.dm_os_sys_info in one query, confirms it with the process memory view and the error log, and explains what each value means.







