• You can change the max memory setting and it takes effect without requiring a restart. Here is a good guide on what to set it to:

    Suggested Max Memory Settings for SQL Server 2005/2008[/url]

    The article only mentions 64-bit specifically, but the recommendations are relevant for 32-bit systems as well.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato