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.
SQL SERVER – Fix: Error 2596 The repair statement was not processed. The database cannot be in read-only mode
Error 2596 stops a DBCC repair because the database is read only. Here is the safe order: back up, single user, read write, repair and check again.
SQL SERVER – 2005 – SSMS – View/Send Query Results to Text/Grid/Files
Three ways to send query results to text, grid or file in SSMS: the shortcuts CTRL+T, CTRL+D and CTRL+SHIFT+F, the toolbar, or the menu bar.
SQL SERVER – Comparison Index Fragmentation, Index De-Fragmentation, Index Rebuild – SQL SERVER 2000 and SQL SERVER 2005
What is Index Fragmentation and how do page splits cause it? How to measure it with DBCC SHOWCONTIG in SQL Server 2000 and sys.dm_db_index_physical_stats in 2005.