| Andrew J. Kelly 2002-10-05, 9:13 pm |
| Chris,
It really depends on each situation. If you have the down time it basically
can't hurt to do it each day but it is rarely necessary to do so. For the
indexes a lot depends on how often you modify the tables and in what way. I
would suggest running DBCC SHOWCONTIG on say a weekly basis and start
comparing the results to see how fragmented the tables and indexes get.
Then you can determine how often to reindex. Start by using DBCC REINDEX on
all the tables as a guideline. As for the CHECKDB run it as often as you
can afford.
--
Andrew J. Kelly, SQL Server MVP
TargitInteractive
"Chris" <ctrailer@xtiva.com> wrote in message
news:#Fy8L#lYCHA.2144@tkmsftngp12...
> What is good practice in how often one should rebuild indexes and Check
Data
> and Index Linkage?
>
> Anyone? thanks
>
>
|