Post reply

Distribute tables between multiple file groups

  • May 15, 2006 at 5:07 am

    #114645

    I have a table that has grown more than 2Gb in size. I have 3 file groups defined for this database.

    I know you can move tables from 1 file group to another, but is it possible to distribute a single table into multiple file groups?

    Thanks in advance.

    Shahid.

  • May 15, 2006 at 8:19 am

    #637870

     

    "

    Microsoft® SQL Server™ 2000 allows you to create tables or indexes on a specific filegroup within your database, rather than across all filegroups in a database. By creating a filegroup on a specific disk or RAID (redundant array of independent disks) device, you can control where tables and indexes in your database are physically located. Reasons for placing tables and indexes on specific disks include:

    • Improved query performance.
    • Parallel queries.

    "

     

    might want to consider partitioning the table

    Kindest Regards,

    Vasc

  • May 15, 2006 at 8:43 am

    #637878

    Partitioning is another option that I am looking into. Any links to some helpful notes please.

  • May 15, 2006 at 8:48 am

    #637880

    BOL -- partitioned views

    Kindest Regards,

    Vasc

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply