Post reply

Partitioning Table FileGroups Question

  • October 10, 2019 at 2:50 pm

    #3687756

    Hi,

    Dear friends,

    Please, What is the best way, to implement, empty filegroups, with the purpose to partitioning a table.

    How, should I define that FileGroup, in terms of space allocation ?

    Any Idea ?

    Thanks

  • October 11, 2019 at 3:10 pm

    #3688069

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • October 13, 2019 at 4:47 am

    #3688270

    Step #1 is to identify WHY you think you want to partition a table.  So WHY do you want to partition whatever table you're working with?  What are some of the stats about the table?

    --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)

  • October 15, 2019 at 1:58 pm

    #3688881

    Hi,

    Thanks for your response,

    I have checked the following conditions:

    1.) I am choosing partitioning because the size of the database does not matter.

    2.) Index maintenance is taking too much time.

    3.) User sensitivity does not allow to run maintenance routine tasks.

    Thanks again for your ideas

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

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