You can use undocumented stored procedure (I have been using it for a couple
years and it's still working like a charm too :)

use database_name
go
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?')"

Julia


-----Original Message-----
From: Christian Pedder [mailto:[Email Address Removed] Tuesday, September 02, 2003 11:45 AM
To: LazyDBA.com Discussion
Subject: RE: index & data fragmentation


I just implemented this and it works like a charm, you can find
more on this
topic at the site.

http://www.sql-server-performance.com/rebuilding_indexes.asp

HTH...
Christian

-----Original Message-----
From: Fang, Elaine [mailto:Elaine.[Email Address Removed] Tuesday, September 02, 2003 2:33 PM
To: LazyDBA.com Discussion
Subject: index & data fragmentation


Hi list,

Is there anyway for me to check if the indexes on a table is
fragmented, so
a reindex is needed?

And what can we do the reduce the fragmentation of table data?
Suppose there
is no clustered index on it, is there anyway for us to reorganize it?

Thanks!

Elaine





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page