Build an error handling template with XACT_ABORT, XACT_STATE, durable error logging, and THROW, then test a forced procedure failure.
SQL SERVER – Finding Size of a Columnstore Index Using DMVs
This script uses sys.indexes and sys.dm_db_partition_stats to list the size of a columnstore index on disk, along with its table name.
SQL SERVER – Service Broker and CAP_CPU_PERCENT – Limiting SQL Server Instances to CPU Usage
Jeff said my Resource Governor script did not limit CPU at all. After a few emails we found why, and how CAP_CPU_PERCENT really limits CPU usage.
SQL SERVER – A Puzzle – Swap Value of Column Without Case Statement
An interview puzzle: write one UPDATE that flips male to female and female to male. Can you swap value of column data without a CASE statement?
A Repeatable Workload: Testing a Tuning Change Fairly
One quick run can fool you. Here is a small, fixed test you can rerun before and after any index.
Replace SELECT * with Column Names in SQL Server: SQL in Sixty Seconds #017
Replace SELECT * with the columns your application needs. The tests here show a query that read 4 pages instead of 64, a view that missed a new column, and two errors that appear when a table changes, all on SQL Server 2025.
SQL SERVER – Fix: Error: 10920 Cannot drop user-defined function. It is being used as a resource governor classifier
Error 10920 stops you from dropping a user-defined function that is still the Resource Governor classifier. Here is why, and how to clean it up.