We're freeing lots of space in a SQL Server 2008 R2 database -a Loooot! enough to care about- (we're dropping lots of unnecessary data). but the database file conserves its file size. we want to regain it.
I've heard lots of times that using DBCC SHRINKDATABASE reduces the performance of your DBs -As far as I know, because "...A shrink operation does not preserve the fragmentation state of indexes in the database, and generally increases fragmentation to a degree" [MSDN]
So I'm planning to use DBCC SHRINKDATABASE and then rebuild our indexes.