Defrag Tool?

A disk defrag doesn't really work with SQL Server, apart
from getting the files in one continuous chunk of disk
space.
However you can defrag the files themselves with the DBCC
INDEXDEFRAG command.
J

quote:

---

>--Original Message--
>I need to know if there are any good tools available to

---

defrag/reindex

quote:

---

>SQL2000 databases? I have to manage my own server and I

---

am not a SQL guru. I

quote:

---

>run Diskkeeper to take care of the physical files, but I

---

need an easy and

quote:

---

>effective way to defrag/reindex the SQL databases.
>Thanks,
>Derek
>
>.
>

---

Thanks, I should have been more specific. Diskkeeper takes care of the
external files, I was referring to defrag internally. But I think Jacco has
me taken care of. Thanks anyway!
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:889901c3e97b$4907e810$a401280a@.phx.gbl...[QUOTE]
> A disk defrag doesn't really work with SQL Server, apart
> from getting the files in one continuous chunk of disk
> space.
> However you can defrag the files themselves with the DBCC
> INDEXDEFRAG command.
> J
>
> defrag/reindex
> am not a SQL guru. I
> need an easy and