I want to run exactly this command:
DBCC SHRINKDATABASE mydb
When I run this just for a while and then kill it, will the physical database file be a little bit smaller?
In other words: Does the command immediatedly free physical disk space during its run, or does it first a full reorganization, and only then free all physical space?
EDIT: We have simple recovery model, so our log file is very small and we only have one big database file.