Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Clustered Key. (Making it unique). Expand / Collapse
Author
Message
Posted Monday, August 20, 2012 3:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, December 14, 2014 3:41 PM
Points: 257, Visits: 1,225
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
Post #1347043
Posted Monday, August 20, 2012 3:38 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 2:53 AM
Points: 1,101, Visits: 5,290
Yes. It is still valid.
It's caled uniquifier.
Post #1347045
Posted Monday, August 20, 2012 3:53 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:22 AM
Points: 40,632, Visits: 37,094
It's described in Books Online, I think under index architecture.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1347051
Posted Tuesday, August 21, 2012 1:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, December 14, 2014 3:41 PM
Points: 257, Visits: 1,225
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=http://www.mssqltips.com/sqlservertip/2082/understanding-and-examining-the-uniquifier-in-sql-server/][/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
Post #1347616
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse