Partition

  • Hi Friends,

    I have a table with more than 30 million records .now i thought of partitioning the table on primary key please suggest me the approach.

  • Many things to do and to prepare for the partitioning:

    The first location and with all details about partitions is here: http://tinyurl.com/3xvo6zg

    After that take a look the script here: http://tinyurl.com/2wlodhl

    And please make a search about partition in the SQLServerCentral you will find many resources!

    http://tinyurl.com/36hw6ke

    Let us now something during the implementation!

    Have a great day!

    Dugi 😎

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • ...Another nice resource about partition: http://bit.ly/aBD7EY

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • ningaraju.n (7/19/2010)


    I have a table with more than 30 million records .now i thought of partitioning the table on primary key please suggest me the approach.

    I usually ask myself a series of questions when the idea of partitioning a table pops-up on my mind, here are the basic ones:

    1- Any particular reason to partition this table?

    2- How many partitions?

    3- What would be the partitioning key?

    4- Would partitioning strategy help during archiving and purging of this table?

    5- Would partitioning strategy improve performance? How and why?

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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

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