Will I need to fix fragmentation after shrinking a database full of only HEAPs?
0
votes
3
answers
993
views
I have a 1 TB database that contains hundreds of quarterly archive tables and I am looking to drop any table older than 5 financial quarters, which will free up ~600gb of space. To provide an example of what the table architecture looks like:
myTable
myTable_Q4_21
myTable_Q3_21
myTable2_Q4_21
myTable2_Q3_21
I am wondering if after dropping these tables and shrinking the database to reclaim the newly freed up space if I will need to either ALTER..REBUILD each remaining HEAP table or put a CX on each table and remove them afterwards.
Asked by Data Dill
(255 rep)
Jan 19, 2022, 01:18 PM
Last activity: Jan 20, 2022, 11:33 AM
Last activity: Jan 20, 2022, 11:33 AM