Post reply

Table Partioning in SQL Server 2000/2005

  • March 4, 2010 at 10:50 am

    #141868

    Hello,

    Can anyone please highlight the differences in implementing the table partioning in SQL SERVER 2000/2005. Whats the difference in the ways we implement it both the versions.

    Thanks

  • March 4, 2010 at 10:52 am

    #1128637

    Easy enough.

    There was no table partitioning in SQL 2000. It's a new feature in 2005, available in Enterprise edition.

    What SQL 2000 had was partitioned views, views whose source query unioned together multiple separate tables.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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