SQL Server 2008 R2 - 10.50.2500.
We have a Database, about 35 GB in size, which has got several tables and indexes. I ran a report 'Index Physical Statistics' and it came up with recommendation for rebuild couple of indexes. I tried to rebuild these indexes, all but few wouldn't. The reindex on these few indexes seems to be taking for ever and i had to cancel the reindex task. Below is the detail of the index on which reindex task was taking for ever:
IndexName Index Type Partitions Depth Operation Recommended
XXXXXX , Nonclustered, 1, 2, Rebuild
Partition Type, Avg Frag%, #Fragments, Avg Pages per Frag, # Pages
1, 50, 2, 1, 2