Stream Aggregate is a common showplan operator, even in a simple COUNT(*) plan. I explain why a Compute Scalar often shows up right before it.
SQL SERVER – Get the List of Object Dependencies – sp_depends and information_schema.routines
sp_depends can return wrong dependency results where information_schema.routines gets it right. See where it fails and the DMVs recommended in its place.
SQL SERVER – Location of Resource Database in SQL Server Editions
The Resource database contains SQL Server system objects. I use version-specific guidance to locate its files and plan recovery.
SQL SERVER – Several Readers Questions and Readers Answers
A collection of readers questions from this blog, with answers from other readers, like how to script table rows as INSERT statements and track changes.
The First Hour on a Server Nobody Can Explain
Investigate a slow SQL Server in a fixed order, checking connectivity, blocking, waits, plans, and storage before changing the environment.
SQL SERVER – Find Statistics Update Date – Update Statistics
Stale statistics can hurt a query plan. Use STATS_DATE to find the statistics update date for each index, then update them if they look outdated.
Building Your Own Sample Data Set
Build a sample data set with realistic keys, skew, NULLs, and repeatable generation when a downloaded sample misses the lesson.







