Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Database fragmentation

Author  Topic 

MichaelP
Jedi Yak

2489 Posts

Posted - 2003-10-01 : 17:15:58
I think I've seen a script that shows how fragmented a database / index is. Anyone know where I can find such a thing?

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-01 : 17:49:28
DBCC SHOWCONTIG

Tara
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2003-10-01 : 18:04:09
/me smacks head

D'oh!

Thanks Tara, bang on target as always.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page
   

- Advertisement -