Post reply

Partioning in Sql server 2005

  • January 30, 2007 at 1:28 am

    #115431

    Hi Guys

     We need to do partioning in sql server 2005. Can anybody help me with these queries.

    1. How to do it?

    2. What is the best possible way?

    3. How many changes need to be done in sql queries?

    4.Is it really beneficial?

    Thanks

    Brij

  • January 30, 2007 at 3:59 am

    #686393

    Brij,

    reading your post I wonder why you "need" to do partitioning. If your not even sure if it's benefical, why you're so sure you need it?

    Trying to answer your questions

    1) Firts of all you need to define a partioning column, which you will use in the partioning function. Then define the partioning scheme. When create or move your table/index on the partioning scheme.

    2) It depends if you want static partitioning or some sliding window partioning where you move old data out of the table into some archive table.

    3) No, you don't need to change you're queries. Only if you use a sliding window with an extra archive table you might need to adjust some queries,

    4) On really large tables, partitioning can improve performance quite significantly. Also index maintenance can be optimized by only rebuilding partions which are fragmented. How mauch benefit you will see depends on the type of query and the placement of the partions on different filegroups/disks.

    Here you find a good whitepaper about partitioning with samples: http://www.sqlskills.com/resources/whitepapers/partitioning%20in%20sql%20server%202005%20beta%20ii.htm

    Hope this helps

    markus

     

    [font="Verdana"]Markus Bohse[/font]

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

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