Why did last quarter’s invoices change overnight? Probably because the rate table had no dates. Here is a lookup that remembers.
Building Full Folder Paths From a Parent-Child Table
Your folder table stores only a name and a parent, so the full path has to be walked. I show the query, and how to catch the rows it quietly leaves out.
Changing a User-Defined Table Type That Procedures Use
You need one more column in a table type, but procedures depend on it. Here is the order of moves that works, with the errors along the way.
Counting Partitions per Table and Spotting Empty Ones
A quick count said 8 partitions, but the table has 4. Here is where the extra rows came from and how to spot empty partitions.
SQL SERVER – Inside Temp table Object Creation – Part II
A first year developer wrote in with a question after my post on temp table object creation. Here is my answer, with a closer look at tempdb.
Temp Table Statistics: Why a #Table Plan Goes Stale
Inspect temp table statistics across procedure calls, compare estimates with loaded rows, and test targeted refresh and recompile fixes.
Temp Table Scope in Nested Procedures and Dynamic SQL
Explain temp table scope across nested procedures and dynamic SQL, reproduce missing and duplicate-name errors, and pass rows safely.