dbcc checkdb (’databaseName’)
Verifies that Index and Data Pages are linked properly,
that Indexes are sorted, that the pointers in the database
are accurate, that the data looks OK, and that there are
proper page offsets.
Advanced checkdb Options:
NOINDEX, REPAIR_FAST, REPAIR_REBUILD, REPAIR_ALLOW_DATA_LOSS

noindex:  Checks the database but not it’s indexes.  Results in faster operation.  If there are problems, make sure to More >