• Welsh Corgi (11/27/2015)


    I am against partitioning in this situation.

    I have archive procedure that is very complex.

    How can I convince my VP that partitioning is not the way to go?

    First - you need to answer - the way to go from where and to where?

    Why do you need to go anywhere?

    What is the problem you're trying to rectify by the move?

    When you the problem clearly formulated you meed to collect possible solutions.

    Then you evaluate pros and contras for each of them and choose the most appropriate For the task.

    So, what is the problem(s) which caused the discussion about partitioning?

    If it's unsatisfactory query performance then you need to look into the clustering of the tables.

    In the following topic I showed how correct clustering makes partitioning irrelevant:

    http://www.sqlservercentral.com/Forums/FindPost1738471.aspx

    If it's not (only) performance issue then other factors must be taken into consideration.

    _____________
    Code for TallyGenerator