Finding unused indexes requires a measured window, SQL Server usage counters, and a safe removal test before an index earns a drop decision.
Describe a Result Set Without Executing Its Query
Describe a result set without running the query. Check column names, data types, nullability and declared parameters.
Grouping Current Connections by Program Name and Host Name
Group connections by program name, host, and login, then inspect client addresses and idle sessions without trusting client labels blindly.
A Simple Dashboard From DMVs
A dashboard from DMVs can show live requests, database state, waits, and backups when its queries refresh without adding load.
Low Memory Signals in the Resource Monitor Ring Buffer
Read the resource monitor ring buffer alongside Windows and process memory signals to investigate cache shrinkage in SQL Server.