Post reply

Clustered Key. (Making it unique).

  • August 20, 2012 at 3:35 am

    #260226

    Dear reader,

    I remember (from 2000 version):

    If the clustered key is not unique. A artificial field is added to make it unique.

    How is this called?

    Where is this described (webpage) ?

    Is this still valid?

    Ben Brugman

  • August 20, 2012 at 3:38 am

    #1527478

    Yes. It is still valid.

    It's caled uniquifier.

  • August 20, 2012 at 3:53 am

    #1527482

    It's described in Books Online, I think under index architecture.

    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

  • August 21, 2012 at 1:48 am

    #1527971

    Suresh B. (8/20/2012)

    Yes. It is still valid.

    It's caled uniquifier.

    Thank you,

    Using the term uniquifier, on line I found:

    [/url]

    In books online I could not find the term uniquifier, neither could I find a description of the phenomem. But that could be my problem with the books on line. (I did use the old BOL a lot, but with the 'new' BOL, I tend to find the information faster on the web).

    Thanks,

    Ben Brugman

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

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