Someone wants to reorder columns to shrink rows. I measured it on SQL Server 2025, and the answer is mostly no, with one small exception worth knowing.
Finding Which Database Uses the Most CPU on a Shared Instance
Find which database uses the most CPU from cached query stats and plan attributes, then use Query Store for restart-safe history.
How to Add Column at Specific Position in SQL Server
To add column at specific position in SQL Server, you have three tested options, because ALTER TABLE always adds the column last. This post shows a SELECT list, a view for loads and reports, and a full table rebuild. It also explains what the rebuild costs.
BACPAC or Backup: When an Export Is the Wrong Tool
A BACPAC export has rows in it, but it is not a recovery backup. Here is a small demo that shows the difference.
Finding Procedures Created With the Wrong SET Options
Find procedures with wrong SET options in sys.sql_modules, understand error 1934, and recreate modules with ANSI_NULLS and QUOTED_IDENTIFIER ON.
SQL SERVER – Check If String is a Palindrome in Using T-SQL Script – Reverse Function
A friend building a captcha had to skip words that read the same backward. Here is a T-SQL script with REVERSE to check if a string is a Palindrome.
Rethrowing Errors With THROW and Keeping the Original Number
A bare THROW passes an error on untouched. A new THROW or a copied RAISERROR message does not. See the proof, plus one semicolon trap.