Inspect temp table statistics across procedure calls, compare estimates with loaded rows, and test targeted refresh and recompile fixes.
DROP IF EXISTS and CREATE OR ALTER for Iterative Deployments
Run your deployment script twice and see what survives. A short demo shows why CREATE OR ALTER keeps permissions and drop and create does not.
SQL SERVER – Need Your Feedback – Next Action Items in SQL in Sixty Seconds
Help me pick the next action items for my SQL in Sixty Seconds series. Leave your idea in the comments, and the three best ones win a gift card.
A T-SQL Cheat Sheet for Everyday Work
This T-SQL cheat sheet gathers daily SELECT, JOIN, GROUP BY, window, TRY_CONVERT, and transaction patterns with short examples.
Finding Encrypted Stored Procedures Before a Migration
Inventory encrypted stored procedures and other modules before migration, then recover their approved source and dependencies.
OPTIMIZED_SP_EXECUTESQL in SQL Server 2025: Fewer Compile Storms
Test OPTIMIZED_SP_EXECUTESQL in SQL Server 2025, inspect compilation counters and cached plans, and compare a concurrent workload.
Compare Showplan: Finding What Changed Between Two Plans
Compare Showplan shows where two plans differ, but not why. Here is a small before and after example you can run yourself.