INDEX REBUILD
=============

DBCC DBREINDEX(@TableName,' ',90)  
    - second argument is blank to rebuild all indexes over the table
    - there are clustered (index organized table) and non-cluster indexes
    - fill factor is PCTDUSED in db-block (page)
 
 
DBCC DBREINDEX 
    (    [ 'database.owner.table_name'    

            [ , index_name 

                [ , fillfactor ] 

            ] 
        ] 
    )    [ WITH NO_INFOMSGS ] 

index_name - Is the name of the index to rebuild. Index names must conform to the rules for identifiers. 

                    - If index_name is not specified or is specified as ' ', all indexes for the table are rebuilt.

fillfactor - Is the percentage of space on each index page to be used for storing data when the index is created. 
           - fillfactor replaces the original fillfactor as the new default for the index and for any other nonclustered indexes rebuilt because a clustered index is rebuilt. 
           -  When fillfactor is 0, DBCC DBREINDEX uses the original fillfactor specified when the index was created.

WITH NO_INFOMSGS - Suppresses all informational messages (with severity levels from 0 through 10).



TABLE INFORMATION
==================
EXEC sp_spaceused 'table_name' 

 

INDEX INFORMATION
=================

EXEC sp_helpindex 'table_name'