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 |
|
omnisysgroup
Starting Member
10 Posts |
 Posted - 2008-01-17 : 22:27:16
|
| My environment is SQL 2000. I have a table with 500 million rows. The table is consistently getting updated and inserted. I can not take the table offline. My clustered index needs to be rebuilt due to decreased performance. The stipulations are you cant upgrade to 2005, do not mention partitioning and you need to not miss any updates or inserts to the table. Does anyone have a viable solution please? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-01-18 : 01:00:13
|
| why cannot it be done offline? Dont you have a scheduled maintenance window? If not its worth taking some time off considering the performance improvement that could be gained.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-18 : 04:53:57
|
| If you absolutely cannot take it offline , you could try a DBCC INDEXDEFRAG. If you look under DBCC SHOWCONTIG in SQL Server BOL , you will see a script that will only defrag based on a certain level of fragamentation. For example, you could extreme ones first . For example , over 80Although I agree with dinakar, it is best to do this under a maintanence windowJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
Rebuild clustered index on 500 million row table??