Home Forums SQL Server 2008 SQL Server 2008 Administration Guidance with shrink and rebuild/reorganise indexes RE: Guidance with shrink and rebuild/reorganise indexes
durai nagarajan
SSCoach
Points: 15775
More actions
July 29, 2013 at 3:33 am
#1636564
Depends on new index size and DB will grow
User DB will never return it to OS automatically and tempdb will not return it till the next SQL restart.
RegardsDurai Nagarajan