SET STATISTICS TIME reports CPU and elapsed execution time for Stored Procedures. A customer wanted to measure a run without adding statements manually.
MySQL Performance – Five Configuration Topics with Version Limits
A MySQL Config File needs settings matched to its server version and workload. I measure pressure before changing a parameter.
MySQL Performance – Slow Query and innodb_buffer_pool_size
A small innodb_buffer_pool_size contributed to one customer slow MySQL query. The comparable SQL Server workload ran quickly.
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.