none
SQL Server 2008 R2 Tables and Indexes on separate FileGroup RRS feed

  • Question

  • Hi Team,

    I am going to create a new database, is it best practice to create all tables in PRIMARY File Group and all indexes of those tables in new user defined/Secondary File Group?   

    FYI.. Among all the tables, two tables in my database has more than 10Million Records.  

    Thanks,

    Ali

    Friday, February 21, 2014 7:37 AM

Answers