• SQLRNNR (5/7/2013)


    Another option is to find the largest table in the database, multiply it by 1.5. Once you have that number, shrink the file to leave at least that amount of free space in the data file.

    Which sounds like a nice round number to me. Doesn't free up quite as much as I'd like, but still frees up about 30GB