September 11, 2004 at 4:04 pm
Howzit guys .
I need some opinions from the SQL lovers out there .
I implemented a Archive solution for our homeloans devision SQL 7 . This was about 450 000 closed cases that had to be sent to Archive + 170 Million rows . Then I had to delete round about 170 million rows from various tables (live system) if they existed in archive of course ..
now my question :
The space usage have not changed much in the database so it means that I must reorg and update the usage and rebuild the indexes ect ect ect ...
In what order would you guys perform these tasks so it would be most beneficial and , I would get all the free space back to the operating system and minimize the fragmentation of the database as well ?
September 13, 2004 at 11:58 am
FYI, it looks like you've posted this to the wrong forum - this forum is for SQL Server 2005 (aka "Yukon"), which is currently in beta. You may want to repost in a more appropriate forum so that you'll get more people to see it.
Not to send you away empty handed ... whatever you do, don't rebuild nonclustered indexes before clustered indexes!
OK, that's cheap advise, but like I said, you probably want to repost in a different forum.
Cheers,
Chris
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply