Shameless self-promotion: https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/

Costs != times

Costs are unitless values that are solely used for the Query Optimiser to decide what plans are cheaper than others. They're not a measure of CPU...

Yup, a design like that will cause recompilations on every execution, and if it's executed frequently will cause compile locks (only one session can be compiling a query at a...

Almost every time I try having a video conference session from home, my cat joins in. Usually by jumping from the windowsill onto my desk, so the other person gets...

Roleplaying (Running a Star Wars Saga game, running an Exalted game, playing in a 5th ed D&D game)
Playing board games
Playing computer games
Reading

I used to do...

The naming is unlikely to be causing the lock. The sp_ prefix means that SQL looks in master and the resource DB before the user DB for the object, that's...

The density in the stats header is useless, ignore it.

You can't, by looking at the histogram, tell whether your stats are good or not.
eq_rows is the...