I've got a table in my SQL Server 2005 database with two indices that are heavily fragmented (33.3% and 85.7%). The table looks like the following:
CREATE TABLE [dbo].[Seasons]( [SeasonID] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [TeamID] [bigint] NOT NULL, [Year] [smallint] NOT NULL, [Name] [nvarchar](50) NOT NULL, CONSTRAINT [PK_Seasons] PRIMARY KEY CLUSTERED ( [SeasonID] ASC )
The other index is on the TeamID column. When I attempt to rebuild the indices in management studio it tells me 'success' on each one. But, when I view the fragmentation again nothing has changed. The table only has 2300 rows in it. Not sure if this is relevant, but I also noticed that it takes a LONG time (on the order of 30 seconds) to pull up the fragmentation info when I right-click an index, choose properties, and then select the Fragmentation page.
Other indices in the DB rebuild without a problem.
Any idea why I can't actually rebuild these indices? Any idea why it takes sooo long to pull up the fragmentation information? Thanks!