• Just by partitioning we cannot be sure to get performance benifit.

    You should look at your queries and execution plans and see partition elimination is happening.

    look at your frequent / long running queries and share the execution plan if you need further help

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]