SQL_Surfer (7/21/2013)
Any idea why DB grows to 10GB more after index maintenance?
Because SQL had to rebuild the indexes somewhere, if there wasn't space for the new indexes, the file would have grown to make space.
Should I opt for shrinkfile?
If you want to completely undo everything that the index rebuild did, leave your indexes more fragmented than before you started, sure.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability