Post reply

Database objects - File group mapping

  • December 19, 2007 at 2:40 pm

    #70537

    I have couple of database objects (Tables - Non- Clustered Indexes) scattered to different file groups onto different drive's. What's the easy way to see which object reside under which file groups?

    Any suggestions?

    Thanks,

  • December 19, 2007 at 4:31 pm

    #761631

    EXEC sp_Help tablename

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 20, 2007 at 8:58 am

    #761788

    If you need to move them, I think you have to rebuild on the new filegroup, dropping the old.

    If you are working with multiple filegroups, I'd be sure you always specify this to be sure things are placed properly.

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

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