Skip to main content
W
WHERE1equals1
September 19, 2025
Solved

Reducing Table Size in OS – Need Advice

  • September 19, 2025
  • 1 reply
  • 0 views

We're trying to reduce the size of a large table in OS (about 650GB). Our initial idea was to copy the rows to a new table and then rename it, but the insert process takes too long due to the size and ends up timing out. Deleting records from the table itself seems risky and take's similar duration. 

Has anyone dealt with something similar? Would appreciate any tips or suggestions for a faster and more efficient approach. Thank you! 

Best answer by JackLacava

Then you don't really have any restriction in what you do (beyond keeping it around for auditing purposes, particularly if it's related to actual numbers). So you can just have a look around for strategies: https://stackoverflow.com/questions/5296106/how-to-copy-a-huge-table-data-into-another-table-in-sql-server 

1 reply

J
JackLacava
September 19, 2025

Depending on which table we're talking about, there will be very different solutions.

A
Anonymous
September 22, 2025

It's an audit table located within Application - Database

 

J
JackLacavaAnswer
September 22, 2025

Then you don't really have any restriction in what you do (beyond keeping it around for auditing purposes, particularly if it's related to actual numbers). So you can just have a look around for strategies: https://stackoverflow.com/questions/5296106/how-to-copy-a-huge-table-data-into-another-table-in-sql-server 

Terms & ConditionsAccessibility statement