On Sunday, November 10, 2013 5:13:03 PM UTC-6, dbaon...@gmail.com wrote:   
   > is there any way to make DBCC checkDB faster?   
      
   I think yes ...   
      
   How can you make DBCC CHECKDB faster?   
   • Do one database a night. Either round robin equally or do more important   
   ones more frequently.   
   • Check individual tables with CHECKTABLE and don't do them all at once (and   
   frequently   
   do the other database level checks that are included in CHECKDB - CHECKALLOC   
   and   
   CHECKCATALOG).   
      
   • Check one partition (assuming each is on a separate filegroup) at a time with   
   CHECKFILEGROUP.   
      
   You can refer below article for more info.   
   http://www.techsql.com/MSSQLServerDatabaseCorruption-CHECKDB.htm   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)