'Truncation of large table in SQL Server database
I would like to completely clear one table in my SQL Server database.
Unfortunately, the table is large (> 90GB). I am going to use the TRUNCATE statement.
The question is whether I should pay attention to something before?
I am also wondering if it will somehow affect the server's disk space (currently about 110 GB free)?
After all the action, SHRINK DATABASE will probably be necessary.
Solution 1:[1]
TRUNCATE TABLE is faster and uses fewer system and transaction log resources than DELETE with no WHERE clause, but if you need even faster solution, you can create new version of the table (table1), drop the old table, and rename table1 into table.
R
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Rownum Highart |