How to Read Statistics Profile

(2006-09-01 added a paragraph on parallel query plans)   In SQL Server, “Statistics Profile” is a mode in which a query is run where you can see the number of invocations of each physical plan operator in the tree.  Instead of running a query and just printing the output rows, this mode also collects and…

8

Locking Backgrounder

A quick post for today.  It’s actually more of a storage engine concept, but you’d be surprised how much this can help in understanding update plans.  So, as I’m re-reading some of these to refresh my memory, I’ll give you the chance to read along, so to speak. For those interested in how and why…

0