Find duplicate statistics on index-leading columns, compare freshness and sampling, and generate cautious DROP STATISTICS candidates.
SQL SERVER – Scrollbar in the Middle – Bugs Fixed by SSMS Team
SSMS 18.5 fixed the Database Properties scrollbar that opened in the middle. Read the funny true story, see the original evidence, and enjoy the fix.
SQL SERVER – Multiple Log Files to Your Databases – Not Needed
I was asked a very interesting question by their DBA about log files. The question was – Is there ever need of multiple log files in SQL Server?
KILL WITH STATUSONLY: How Long Will This Rollback Take?
Read KILL WITH STATUSONLY rollback estimates, confirm the target session, avoid repeated kills, and account for accelerated recovery.
SQL SERVER – SQL_NO_CACHE and OPTION RECOMPILE Target Different Caches
OPTION (RECOMPILE) and SQL_NO_CACHE concern different cached objects. A banking customer using MySQL and SQL Server prompted my comparison.
Schema Discovery for JSON Columns: Listing Every Key With OPENJSON
Use schema discovery on JSON columns to count keys and types, inspect nested objects, and find missing required paths with guarded input.
Twenty Practice Queries on One Small Schema
Work through twenty practice queries on one small sales schema, with expected results for filters, joins, totals, windows, and gaps.