Post reply

Partitioning

  • March 2, 2015 at 11:57 am

    #294948

    Is it a good practice to ask your manager for downtime before implementing partition?

  • March 2, 2015 at 12:21 pm

    #1781191

    iqbalbutt (3/2/2015)

    Is it a good practice to ask your manager for downtime before implementing partition?

    You should keep this question with the questions you asked about downtime on partitioning where I stated that, if you do it right, you won't really need any downtime for it.

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

  • March 2, 2015 at 1:17 pm

    #1781201

    iqbalbutt (3/2/2015)

    Is it a good practice to ask your manager for downtime before implementing partition?

    Please don't open another thread for the same topic. Continue using the one you created.

    Also, don't want to sound rude, but if you are asking that question, it does not sound like you really fully understand how partitions works. On that case, my advice would be read a whole material about it, test on a Dev box, and then ... if you have questions, you can post those here and people will help you. Who knows... maybe then you will realize that partition is not for you or it will not "solve" any issues you may already have.

    If I was your manager and you're about to partition TB of GB of data and you are not sure of how it works before implement, I would not feel comfortable you doing it.

    Partition is actually a tricky and complex topic.

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

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