468,283 Members | 1,982 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,283 developers. It's quick & easy.

Rebuild Index Fails, need insight

All efforts to rebuild indexes fails. Not with an error, but they still show high fragmentation.

The environment:
SQL Server 2005 in 2000 compatibility mode
non-clustered indexes on tables that have clustered indexes with unique constraint

Tried so far:
Rebuild, reorganize, manual drop and recreate, setting the db in 2005 mode

This only seems to happen on the tables that also have the clustered index with a unique contraint ( which seem to defrag fine on said tables).

I haven't seen this before, can anyone shed some light on it?

Thanks,
Scott
Feb 25 '08 #1
1 1309
DBCC SHOWCONTIG

[HTML]http://msdn2.microsoft.com/en-us/library/ms175008.aspx[/HTML]

Have you ran DBCC INDEXDEFRAG?

[HTML]http://msdn2.microsoft.com/en-us/library/ms177571.aspx[/HTML]

sys.dm_db_index_physical_stats

[HTML]http://msdn2.microsoft.com/en-us/library/ms188917.aspx[/HTML]

If i understand you question these should help.
Feb 27 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Steve | last post: by
2 posts views Thread by Peter Lindquist | last post: by
10 posts views Thread by wackyphill | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.