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 emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
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 slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.