REINDEX and INDEXDEFRAG

I am currently working on researches on INDEXDEFRAG and REINDEX. I
would like to know what is the best thing to use REINDEX or
INDEXDEFRAG' Since we are currently maintaining a large amount of
data(about 20 Gig) and we are in a hospital that is why i'm finding a
way to do indexing that will not lock the system so the users can still
use the system
thank you..You would want to check the following article for the
differences, guidelines for implementing in your
environment:
Microsoft SQL Server 2000 Index Defragmentation Best
Practices
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
-Sue
On 20 Mar 2006 19:39:04 -0800, "Ludy Doctor"
<mismld@.hsc.dlsu.edu.ph> wrote:
>I am currently working on researches on INDEXDEFRAG and REINDEX. I
>would like to know what is the best thing to use REINDEX or
>INDEXDEFRAG' Since we are currently maintaining a large amount of
>data(about 20 Gig) and we are in a hospital that is why i'm finding a
>way to do indexing that will not lock the system so the users can still
>use the system
>thank you..|||Hi Sue!!!! thanks for that...one more thing...can you help me set up a
failover cluster in SQL 2000?|||Check the following article:
SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
It's also explained in books online - check the help topic:
Failover Clustering
-Sue
On 21 Mar 2006 00:40:04 -0800, "Ludy Doctor"
<mismld@.hsc.dlsu.edu.ph> wrote:
>Hi Sue!!!! thanks for that...one more thing...can you help me set up a
>failover cluster in SQL 2000?