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 |
|
Kleber
Yak Posting Veteran
67 Posts |
 Posted - 2004-03-02 : 15:22:29
|
| HelloI have a table with 22Gb, and now i want to delete it, so i ask, how should i do it, with less impact to my prodution enviroment?Droping the table ou deleting the registers and them droping the table?How could i measure it?Tks for your timeKleberBrazil |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-02 : 15:36:26
|
| Just drop the table. Then run DBCC UPDATEUSAGE after-hours to correct the usage information.Deleting the table, then dropping it will be very slow. So skip the delete part.Tara |
 |
|
|
saglamtimur
Yak Posting Veteran
91 Posts |
Posted - 2004-03-02 : 15:42:29
|
| If you dont need it anymore, droping could be fine, but if you plan to use it again in sometime may be truncating is better than deleting. See BOL for "TRUNCATE TABLE" statament. |
|
|
|
Kleber
Yak Posting Veteran
67 Posts |
Posted - 2004-03-03 : 06:21:53
|
| Thanks folks...you are the best.Kleber |
|
|
|
|
|
|
Drop table or Delete Statement???