Hi Craig,

For (1) DBCC Showcontig
(2) DBCC INDEXDEFRAG

Look up BOL for more info.

HTH,
John

-----Original Message-----
From: Craig Rosenblum [mailto:[Email Address Removed]
Sent: Thursday, September 11, 2003 9:11 AM
To: LazyDBA.com Discussion
Subject: Safe Re-indexing practices..

How can I be sure if my tables need re-indexing or defragging??

And what is the safest way to re-index or defrag them, and still allow
people to access the database. Since this is used for a website. I can
not afford to take the site down.



The terrorists wanted Sept. 11 to be a day when innocents died.
Instead it was a day when heroes were born.
-Defense Secretary Donald Rumsfeld, at the Pentagon.


---------------------------------------------------------------------
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