Earlier I wrote how to find the count of tables used in queries from cache. Here is the Count Table in Cache video in SQL in Sixty Seconds.
COMPRESSION_DELAY Option for Columnstore Indexes: Test It
The COMPRESSION_DELAY option keeps a closed delta rowgroup uncompressed for a number of minutes, so rows that change soon after they arrive are cheaper to modify. This post loads two demo tables, updates fresh rows in each, and shows the deleted rows that early compression leaves behind.
SQL SERVER – MARK_IN_USE_FOR_REMOVAL Cache Scope and Costs
To Remove Unused cache entries, I first inspect cache and workload evidence. My original intervention followed other customer tuning work.
Fragmentation in Columnstore Indexes: Find and Fix It
Fragmentation in columnstore indexes means deleted rows that stay inside compressed row groups, and row groups that are too small. This post builds a demo table, measures the deleted rows with the row group view, and compares REORGANIZE with REBUILD.
SQL SERVER – Diagnosing SINGLE_USER Errors Without a Universal EMERGENCY Workaround
Giving Error during a SINGLE_USER change requires the exact error and database state. My original case lacked enough diagnostic detail.
Check Trace Flag Status With DBCC TRACESTATUS
DBCC TRACESTATUS checks trace flag status. Run it with -1 to list every flag that is on, or with flag numbers to test them one by one. This post turns on a harmless session flag, reads its scope, finds startup flags, and stores the result in a table.
Table Usage in the Plan Cache: Count Queries That Touch a Table
Table usage in the plan cache shows how many times the cached queries of a database touched each table. This post builds a demo database, shows why a text search of the cache misleads, reads the table names from the plan XML, and lists the queries behind one table.