By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,208 Members | 1,550 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,208 IT Pros & Developers. It's quick & easy.

Rebuild Index Fails, need insight

P: 2
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
Share this Question
Share on Google+
1 Reply


sleepydog3
P: 7
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.