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.
Experience – My Very First YouTube Live
My very first YouTube Live started with a microphone problem. Here is my honest look at what went well, what I must improve, and the topics we covered.
SQL SERVER – Legal CASE Defaults and Row Dependent Values
A CASE Expression can appear in a default, but cannot reference another row column there. My earlier blanket prohibition was incorrect.
Queries Using Specific Index – SQL in Sixty Seconds #180
The challenge I face is that often DBAs ask me to prove that indexes are really not used by queries. Let us learn about Queries Using Specific Index.
Self-Referencing Foreign Keys: Managers, Employees and Deletes
Delete a manager and SQL Server says no, which is good. See how to reassign reports safely and how to catch loops the foreign key allows.
SQL SERVER – Find Instance Name for Availability Group Listener
An Availability Group Listener identifies a connection endpoint rather than a separate engine instance. I query where this connection actually arrived.
SQL SERVER – Altering Column – From NULL to NOT NULL
Altering Column nullability to NOT NULL requires resolving existing NULLs under an approved data rule. A customer used empty strings.