We are going to discuss Troubleshooting High CPU in SQL Server. This is why many hire me for Comprehensive Database Performance Health Check.
Reading Performance Counters in T-SQL Without Misreading Them
Read SQL Server performance counters with two timed samples, a proper ratio base, and a concise workload and memory dashboard.
Generate Script of SQL Server Objects – SQL in Sixty Seconds #184
Today we will see the same concept translating in the video. Let us learn about Generate Script of SQL Server Objects in video format.
SAVE TRANSACTION: Roll Back Half a Transaction
SAVE TRANSACTION sets a marker inside an open transaction. You can roll back to it and keep the earlier work. This post tests it on SQL Server 2025. It shows why a nested BEGIN TRAN can’t do the same and what XACT_STATE() returns after an error.
SQL SERVER – NOLOCK with DMVs
NOLOCK with DMVs is not a blanket reassurance against monitoring waits. A customer asked about omitting the hint.
Aggregate Pushdown: Letting the Columnstore Scan Do the Summing
Verify aggregate pushdown in columnstore scans, inspect locally aggregated rows, and compare numeric aggregates with expressions.
SQL SERVER – Get Last Restore Date
I report Restore Date from the latest retained msdb history row. My earlier query returned every matching entry.