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 |
|
steel
Posting Yak Master
107 Posts |
 Posted - 2009-01-13 : 03:56:29
|
| Dear All,I have a question that if there is a very large table of more than 40 GB size and having one clustered index and some other non-clusterded indexes ,and i want to rebuild the indexes then what is efficient way to do this. |
|
|
raveekumarg
Starting Member
36 Posts |
Posted - 2009-01-13 : 07:12:22
|
| better do it off-line even though 2k supports on on line it is not advisable to create while dml operations is going onravi |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-13 : 08:50:32
|
| and make sure you do it at a comparatively idle time not to create a bottleneck |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-13 : 10:29:09
|
quote:
Originally posted by raveekumarg
better do it off-line even though 2k supports on on line it is not advisable to create while dml operations is going onravi
SQL 2000 doesn't support online indexing.Steel,Use Tara's script and do it in offline hours. |
|
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2009-01-14 : 09:10:04
|
| where to find Tara's script |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
how to create indexes on a very large table