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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-27 : 12:10:23
|
| Selvaraaj writes " I have created several tables and deleting them frequently. Due to this reason the logspace has been raised enormously. But in Oracle we can use the REUSE command for the delete queries in order to delete the physical space of that table/row. I want to know how to reduce physical space while delete query executing. to avoid more space occupied by the log. In this situtaion log file increased and crashed the database. Kindly provide some solution to me As soon as possible.with regards(D,Selvaraaj)" |
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2006-02-27 : 15:19:24
|
| I am not sure that I fully understand your question but this might help.From BOL:"TRUNCATE TABLE is functionally identical to DELETE statement with no WHERE clause: both remove all rows in the table. But TRUNCATE TABLE is faster and uses fewer system and transaction log resources than DELETE."If you need to shrink your tlog... lookup DBCC SHRINKFILE in BOL: |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
activecrypt
Posting Yak Master
165 Posts |
|
|
|
|
|
how to reduce the log file size in sql server 2000 Database