I have a multi databases SQL instance with a total size of 886GB.
I ran a large delete records and drop tables script in a purging process, Then I ran shrink script on all databases.
The size went down to 517GB, Yet after running the re-indexing job it went up to 635GB.
Does re-indexing job increase log file size? or else what cause this size increase?
View Complete Post