DBCC CLEANTABLE can reclaim selected space left after dropping variable-length columns. I distinguish that table operation from shrinking a database file.
SQL SERVER – 2005 – Display Fragmentation Information of Data and Indexes of Database Table
How do you find Fragmentation Information for a table in SQL Server 2005? DBCC SHOWCONTIG has limits, so I use sys.dm_db_index_physical_stats instead.
SQL SERVER – DBCC CHECKDB Introduction and Explanation – DBCC CHECKDB Errors Solution
DBCC CHECKDB checks database consistency. If it reports corruption, I preserve the output and establish the recovery options.
SQL SERVER – Types of DBCC Commands When Used as Database Console Commands
The four types of DBCC Database Console Commands: maintenance, miscellaneous, informational and validation, with a couple of examples of each from MSDN.
What RESTORE VERIFYONLY Checks and What It Misses
RESTORE VERIFYONLY checks backup readability and checksums, but it cannot prove a full restore or healthy data; pair it with restore tests.
SQL SERVER – 2005 – Find Database Status Using sys.databases or DATABASEPROPERTYEX
Find database status such as ONLINE, OFFLINE, RESTORING or SUSPECT using sys.databases or DATABASEPROPERTYEX, and learn what each status means.
SQL SERVER – 2005 – Explanation and Script for Online Index Operations – Create, Rebuild, Drop
What are online index operations? SQL Server 2005 Enterprise Edition can create, rebuild and drop indexes without locking tables, and I explain how.