April 25, 2013 at 2:50 am
Good Day.
I noticed that DBCC dbreindex is still available in 2008R2 . Wehn we run this utility to rebuild PK Custered COnstraints, the Constraints are not droppedd/disbled and the clustered index is not rebuilt . We had to manually drop the Clustered Constraint and the dependent Foriegn Key Constraints before we could rebuild the Clustered Index . For me it looks like a very long an complicated process that is prone to mistakes. Any ideas ?
Ps. I used the Alter Index Rebuild clause and I was reminded that there was a Foreign Key Constraint present.
April 25, 2013 at 3:03 am
lianvh 89542 (4/25/2013)
Good Day.I noticed that DBCC dbreindex is still available in 2008R2 . Wehn we run this utility to rebuild PK Custered COnstraints, the Constraints are not droppedd/disbled and the clustered index is not rebuilt . We had to manually drop the Clustered Constraint and the dependent Foriegn Key Constraints before we could rebuild the Clustered Index . For me it looks like a very long an complicated process that is prone to mistakes. Any ideas ?
Ps. I used the Alter Index Rebuild clause and I was reminded that there was a Foreign Key Constraint present.
Hi
Did you read this http://msdn.microsoft.com/en-us/library/ms181671(v=sql.105).aspx ?
Regards
IgorMi
Igor Micev,My blog: www.igormicev.com
April 25, 2013 at 5:12 am
Thank you for the feedback. The article cleared a lot of misconceptions.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply