The rows are gone but the table is the same size and scans are just as slow. Here is why, and two ways to fix it.
Append-Only Ledger Tables for Audit Logs That Cannot Be Edited
Can someone quietly edit your audit table? With an append-only ledger and a stored digest, the answer becomes no, and you can prove it.
Primary Data File Extensions: Does the .mdf Name Matter?
Can a primary data file end in something other than .mdf? I built a demo database with odd names, checked each file, then detached and attached it.
SQL SERVER – FIX – The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run
After a backup restore mistake, SQL Server would not start and ERRORLOG said the database ‘model’ is marked RESTORING. This is how I got it running again.
Default Filegroup: Sending New Tables Away From PRIMARY
Changing the default filegroup only affects tables you create later. Here is what moves, what does not, and how a script can quietly ignore the rule.
Capping File Growth So One Query Cannot Fill a Whole Disk
One runaway load can fill a shared drive and take every database down with it. A MAXSIZE cap moves the failure to one database.
Metadata-Only Column Changes: Which ALTER COLUMN Is Instant
Six ALTER statements look equally small, but their log cost is not. Here is how to measure each one before the change window.