Partitioning Table FileGroups Question

  • luismarinaray

    SSCrazy

    Points: 2800

    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

  • Site Owners

    SSC Guru

    Points: 80379

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

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

  • Jeff Moden

    SSC Guru

    Points: 995714

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "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)

  • luismarinaray

    SSCrazy

    Points: 2800

    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 4 (of 4 total)

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