Hi Vaibhav Chaudhari,
When to rebuild index - http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f2caeaca-3ec8-49c2-a2a8-a27dddd80ac6/rebuild-index-is-taking-time-more-than-expected-sql-2005
What should be done before rebuilding nonclustered index - http://technet.microsoft.com/en-us/library/ms177406%28v=sql.105%29.aspx
sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.
No comments:
Post a Comment