• To be clear:

    The min server memory and max server memory options are advanced options. If you are using the sp_configure system stored procedure to change these settings, you can change them only when show advanced options is set to 1. These settings take effect immediately without a server restart.

    From http://technet.microsoft.com/en-us/library/ms178067(v=sql.105).aspx

    🙂