Post reply

Advantages of Table partitioning on MSSQL 2005?

  • May 13, 2008 at 2:36 am

    #190498

    My app needs to copy the data to 7 dbs in MSSQL 2000. For performance improvement, I performed a simple test on Table partitioning on MSSQL 2005. It seems reduce the query(select) issue; while cause a bit latency on insert. iS that the actual reason MSSQL 2005 incorporates this feature (external as one table but different file; instead of user scatters the data into many db?

  • May 13, 2008 at 9:22 am

    #814584

    Yes. That's the basic purpose of partitioned tables.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • May 13, 2008 at 5:56 pm

    #814884

    greats, thxs for the reply!

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

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