Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Paul / Ryan

Author  Topic 

Kristen
Test

22859 Posts

Posted - 2005-09-29 : 12:10:26
Not data corruption, but there's a guy in another forum trying to mount a CLUSTERED INDEX on a 140,000,000 row table and it ran for more than 23 hours before some bright spark pulled the plug.

If you guys can help with whether it is likely to need to take that long, and if not what might be amiss, he can be found:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55805

Cheers,

Kristen

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-09-29 : 16:36:33
Looks like its been covered. I posted one clarification to help.

(Edit: btw, we do both read the other forums too)

Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2005-09-30 : 00:11:47
Thanks Paul.

"we do both read the other forums too"

Noted - I kinda assumed you guys wouldn't have had time other than to dip in and out in other conferences. Its good to have you around - I've learnt a great deal from your posts, many thanks.

Kristen
Go to Top of Page
   

- Advertisement -