Post reply

What is the difference between Sql server 2005 and sql server2008

  • March 26, 2012 at 12:52 am

    #150852

    I want to know in relation with partitioning

  • March 26, 2012 at 10:08 am

    #1464391

    SQL Server 2005: Partitioned Table and Index Concepts

    SQL Server 2008 R2: Partitioned Table and Index Concepts

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • March 26, 2012 at 11:57 am

    #1464457

    sarangphadnis (3/26/2012)

    I want to know in relation with partitioning

    As far as I understand the major development is in the locking escalation process which has now added the "partition" level; this is good because some "table" level locks will be avoided by just locking at "partition" level if needed.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • March 27, 2012 at 4:34 am

    #1464844

    3

    2008 - 2005 = 3 :hehe:

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

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

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