Tips, Tricks, and Advice from the SQL Server Query Optimization Team

(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...

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...