SET STATISTICS TIME reports CPU and elapsed execution time for Stored Procedures. A customer wanted to measure a run without adding statements manually.
SQL SERVER – Using NOEXPAND with Indexed View
NOEXPAND treats an indexed view as stored indexed data instead of expanding its base tables. Customer results have differed.
SQL SERVER – Parameter Sniffing and Bad Plan
Disabling parameter sniffing does not guarantee that a bad plan becomes good. That remains my answer to the customer question.
Parallelism in Express Edition: What the Limits Mean
Parallelism in Express Edition has its own reason code in the execution plan. This post reads that reason, shows the settings that keep a plan serial on any edition, and tests the check on a demo table.
SQL SERVER – Dirty Pages Clean Pages and the Correct Cache Commands
Clean Pages have no outstanding data-file write, while dirty pages contain unwritten changes. A customer asked which state was better.
Cost Relative to the Batch: Why One Query Shows 100%
Cost relative to the batch is a share of estimated cost. See why one query shows 100% and when the percent points at the wrong statement.
Find Queries Using an Index in the SQL Server Plan Cache
Find queries using an index by searching cached plans for its exact name. See the script, a surprise result, and what an unused index costs in SQL Server.