SQL Server Performance Forum – Threads Archive

DBCC CHECKTABLE

How often should I run this command?

---

I think just if you have any error message from Maitenance Jobs.
More often you should run Update Statistics and DBCC SHOWCONTIG to find fragmented indexs.
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

---

Thanks

---

.. and additional information on DB maintenancehttp://www.sql-server-performance.com/sql_server_maintenance.asp if you care so. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

]]>