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.
Resource Governor Workload Groups and Pools: A Simple Setup Example
Resource Governor workload groups let you limit CPU and memory for competing workloads. This introduction answers what Resource Governor is and why you need it, then shows a full T-SQL setup example.
SQL SERVER – A Puzzle Part 4 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
Part 4 of my SEQUENCE puzzles uses a DECIMAL sequence that counts down by 1 and cycles. Can you guess the next value SQL Server 2012 returns?
A Letter to the Developer Starting Out
A letter to every developer starting out: it’s fine not to know, your hands learn slower than your head, choose people over perks, keep your promises and keep learning. One day you will be the one standing beside the bench.










