May 9, 2002 at 12:53 pm
Has anyone encountered good 3rd party reorg tools for SQL server 7.0 and 2000 that you can recommend?
May 9, 2002 at 2:20 pm
What do you mean reorg tools to be sure I have the right concept?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 9, 2002 at 2:50 pm
I mean a tools that will execute "DBCC DBREINDEX". We have a 380GB SQL 7.0 database. Currently we are performing archiving, but afterwards we need to reorg the database or at least the largest and most accessed tables.
quote:
What do you mean reorg tools to be sure I have the right concept?"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 9, 2002 at 4:37 pm
Not sure if any tools do it, though I suspect DBArtisan from Embarkadero will do this. Be easy to write a script to handle this based on table changes though.
Steve Jones
May 10, 2002 at 4:55 am
Actually there is I believe a script in BOL that you can execute afterwards to do all the reindexing. Most of the items like DBCC DBREINDEX are also real easy to script out.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply