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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2007-03-15 : 16:14:53
|
| There is a table need truncate and then insert a huge data (more than million rows) every day. Does database grow up every day? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-15 : 16:24:54
|
| It depends on what settings you have for the database. Do not shrink the database to reclaim the disk space as obviously it needs more if it keeps growing.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-03-15 : 16:25:42
|
| If your database is set to auto-extend then it will extend as necessary.If you delete 1,000,000 and then insert 1,000,000 the database won't grow. However, inserting 1,000,000 rows is a big transaction (if all-done-in-one) and that may increase the size of your TLogs.Kristen |
|
|
|
|
|
|
Does database need to shrink after truncating?