"In this recipe we will see how to receive an information about fragmentation and statistics. Then we'll use the knowledge to create automated reindexing script.\n", "Information about freagmentation ...
Get a detailed list of indexes, including type, size, amount of fragmentation, and other attributes. Detect index and table fragmentation, including clustered index fragmentation, nonclustered index ...