Home Forums SQL Server 2005 Administering Database Design: Should we have Multiple Data files and Multiple File Groups – SQL Server 2005 RE: Database Design: Should we have Multiple Data files and Multiple File Groups – SQL Server 2005

  • For a small database I wouldn't worry about it.

    But if you want to keep user objects out of the Primary data file, consider the use of DDL triggers to check if a user object is being created on the Primary file and roll it back.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service