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.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-06-16 : 15:29:15
|
| I have 2 questions, 1. I am trying to create an index, which is running for a long time. Is there an option to know the progress so far or how much more time it is going to take?2. Is there anyway to find out how much space is required to rebuild an index?------------------------I think, therefore I am - Rene Descartes |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-16 : 16:49:35
|
quote:
Originally posted by ravilobo
I have 2 questions, 1. I am trying to create an index, which is running for a long time. Is there an option to know the progress so far or how much more time it is going to take?2. Is there anyway to find out how much space is required to rebuild an index?------------------------I think, therefore I am - Rene Descartes
1) You must be creating clustered index on huge table.Well it has to sort all records and locks table as well. |
 |
|
|
|
|
|
Index creation Progress