• RonKyle (5/4/2015)


    It's not just the defaults. Almost every database I come across has a single PRIMARY file. I always separate the system tables out like so:

    Changing the file group default from PRIMARY ensures that the user objects stay separate from the system objects.

    Why or how does this matter? I understand what you are doing, but not how it benefits the DBA or the system.

    On Steve's main point I have seen a number of vendor provided scripts that fail due to incorrect assumptions, but trying to get your vendors to improve is almost as difficult as putting a man on the moon.

    Dave