I know how to perform an offline defragmentation - I am just curious as to what criteria the community uses as to when to run an offline defrag. Boss saw a few dbs with about 30% whitespace and now wants to offline defrag all databases.
So what do you suggest - a certain percentage of whitespace? When we need the room?