• I typically made the following changes:

    1. Change the file growth settings from percentages to fixed growths of 512MB (or 1GB depending on what the server is used for - and turn on IFI at the OS-level)

    2. Set a fixed starting size for the default data and log files

    2. Ensure the page verification is set to CHECKSUM

    The rest of the defaults seem good enough to me (for what I've always needed :-D)

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience