Home Forums SQL Server 2008 SQL Server Newbies on primary RE: on primary

  • April 1, 2013 at 6:32 am

    #1602434

    It's not required. Leave it off and the table or index gets created in the default filegroup. That's Primary by default, but can be changed

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass