July 23, 2008 at 7:23 am
I have a 9.4 gig database with about four tables that are using the most space. I am trying to think of how I will delete the data out of it as there are no indexes on them. On top of it, it seems that I will need to put the data onto a DVD for permament storage. The db is heavily used during the day 8 am to 6pm.
I have another server that I can restore to and do the export. The delete part, I guess I am going to have to do it on the production server. I have a script that can delete x rows at a time in a transaction. I think I need an index so it won't get bogged down with table scans every time. I believe when I go to build index, we will have a lot of lock timeouts and what not. Is there any way in SQL 2000 to build an index "safer"?
July 23, 2008 at 7:42 am
search Luke search yielded http://www.sqlservercentral.com/Forums/Topic416687-5-2.aspx
🙂
July 23, 2008 at 9:15 am
Sailor (7/23/2008)
search Luke search yielded http://www.sqlservercentral.com/Forums/Topic416687-5-2.aspx🙂
Soooo... you're good?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 23, 2008 at 9:50 am
rbarryyoung (7/23/2008)
Sailor (7/23/2008)
search Luke search yielded http://www.sqlservercentral.com/Forums/Topic416687-5-2.aspx🙂
Soooo... you're good?
yep, will do a dts to an archive db which go onto a dvd, then truncate away!
July 23, 2008 at 10:45 am
OK, great.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 24, 2008 at 8:43 am
So, your tables have no indexes? Even no clustered index?
I had a table recently with no clustered index, taking up 23GB, and growing every day by 50MB. After adding a clustered index (a new UID column + clustered index on it), which took ~2 hours to do, the table size decreased to 900MB, and now only grows 1MB per day.
Do you know if you have a lot of wasted space in your database?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply