Elaine,

Look up DBCC showcontig command in BOL.

John

-----Original Message-----
From: Fang, Elaine [mailto:Elaine.[Email Address Removed]
Sent: Tuesday, September 02, 2003 11:33 AM
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]MS Sql Server LazyDBA home page