I actually run the RecordAllIndexStats before AND after the RebuildFragmentedIndexes procedure. This gives me a before/after picture with the following query:

SELECT RTRIM(a.DatabaseName + '.' + a.TableOwner +...

The SAP database that I'm working with is currently only 16GB but anticipated to grow beyond 500GB when put into production. So, I use the density stats in my...

I developed the following stored procedure to archive density information about clustered indexes for every user database:

CREATE PROC RecordAllIndexStats

AS

SET NOCOUNT ON

SET ANSI_WARNINGS OFF

DECLARE @tablename ...