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.
| Author |
Topic |
|
Dasck
Starting Member
1 Post |
 Posted - 2008-06-25 : 03:49:42
|
| Hi All, I am very new to SQL server and I am working on SQL 2000 Sever. I want to find out the top 10 worse fragmented indexes in the database. Can some one help me with a query to get this information?Thanks you. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-06-25 : 03:53:01
|
DBCC SHOWCONTIG WITH ALL_INDEXES, TABLERESULTS
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
worse fragmented indexes