• Anders

    Yes, shrinking a file reduces the physical space it takes on disk.  Without a shrink, the space that the deleted rows took will be available for more data to be added to the database, but not available to the operating system.  (That's a simplification, since it doesn't take into account free space on data pages, which won't be recovered unless you rebuild your indexes and/or tables.)

    John