making a non-unique clustered index unique

• King Kong

  Grasshopper

  Points: 11

  More actions

  October 18, 2006 at 6:37 am

  #173188

  Hi!

  In what circumstances should we consider adding a composite column to a non-unique clustered index in order to make the index unique, rather than letting the SQL Server database engine add an uniquefier?

  Thanks in advance.

  ~Avnip

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  October 19, 2006 at 10:06 am

  #666851

  Check out this thread from another great site:

  http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=16874

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."