Timeline for Moving data into an archive table and reducing the size of the original table
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 11, 2017 at 16:02 | comment | added | Aaron Bertrand | @MrVimes The goal of my approach is not to free up space. It's to prevent an immediate space explosion. | |
| Feb 11, 2017 at 13:09 | comment | added | MrVimes | Thankyou for this. Wouldn't this require an index rebuild to reclaim the space? or would this scenario be one that frees up internal space for the db to then have room to regrow without taking up more space on the disk. Edit: Just so you're aware, I won't be able to try this (or other possible solutions) until possibly next week. | |
| Feb 10, 2017 at 14:43 | history | answered | Aaron Bertrand | CC BY-SA 3.0 |