3 years after its last publication, this article still sounds great
I think that it dismissed a T-SQL command that is a good alternative of running 'DBCC DBREINDEX (tablename)' :
ALTER INDEX ALL
REBUILD WITH ( PAD_INDEX = ON, FILLFACTOR = yourfillfactor )
dbreindex offer the fillfactor paramter only if you specify an index; if not, or if fillfactor is not provided, it will use (and fill) 100%.
So any new insert will make a split of page (think about uniqueidentifier datatype, which will not be 'sequential'
Alter index offer pad_index and fillfactor (default is 0, value of freespace this time).
An other great reason is that you'll be able to rebuild the indexes for a partition, so only where it must be.
what do you think about that ?
My MCP Transcript
(ID : 692471 Access : 109741229)