dropping a column doesnt create space at all..?

Question

dropping a column doesnt create space at all..?

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 1

PaulB-TheOneAndOnly (12/3/2010)
Brandie Tarvin (12/3/2010)
Repopulating a table isn't necessarily that easy. Especially if it has foreign keys, indexes, constraints, etc. If it's a heap, then not so bad. But you're also forgetting the question of whether or not this table is in Production and the company in question is subject to SOX laws (or other laws that make it illegal to mess with the database using such a quick fix and no documentation).
Brandie,
We do reorg very large tables with FKs, Indexes, Constraints, Triggers, etc., all the time - that's what we call "maintenance".
Last but not least, please point me to the exact SOX paragraph where it says you cannot reorg a table - that's rubbish.

I'm not talking "reorg". I'm talking manual delete and recreate of the table that could cause a problem. SOX is all about financial controls and documentation. If you are subject to SOX law and just go around deleting and recreating tables with financial information in them, without following your internal controls and having these changes documented, it is indeed illegal.

SOX Law Summary (http://www.soxlaw.com/s802.htm)
Summary of Section 802
This section imposes penalties of fines and/or up to 20 years imprisonment for altering, destroying, mutilating, concealing, falsifying records, documents or tangible objects with the intent to obstruct, impede or influence a legal investigation. This section also imposes penalties of fines and/or imprisonment up to 10 years on any accountant who knowingly and wilfully violates the requirements of maintenance of all audit or review papers for a period of 5 years

Now, I'm not saying you will get in trouble. Just that you shouldn't do such drastic things without knowing what the consequences, legal and otherwise, will be.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 2

dropping/recreating indexes on the table and then shrinking datafile worked. Thanks everyone.!!

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 3

Glad we could help.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.