ALTER SCHEMA can Move a Table between schemas within one database. A customer had imported under the wrong schema.
Generate a Date Range: List All Dates Between Two Dates
To generate a date range in SQL Server, number the days between a start date and an end date and add each number to the start. This post shows a recursive CTE, its limit of 100 recursions, GENERATE_SERIES, a version for older servers, and how to handle times and missing days.
Count Table in Cache – SQL in Sixty Seconds #149
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.