1. DBCC CHECKDB
http://technet.microsoft.com/zh-cn/library/ms176064.aspx
http://blog.csdn.net/downmoon/archive/2010/07/20/5748389.aspx
2. DBCC CHECKALLOC
3. DBCC CHECKTABLE
4. DBCC CHECKFILEGROUP
5. DBCC CHECKCATALOG
6. DBCC CHECKIDENT
7. DBCC CHECKCONSTRAINS
Refer to: http://blog.csdn.net/downmoon/archive/2010/08/04/5788887.aspx