Hi.

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

ON [tablename]

REBUILD WITH ( PAD_INDEX = ON, FILLFACTOR = yourfillfactor )

Why ?

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 ?