Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Clustered indexes

Author  Topic 

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-05-03 : 18:19:42
Hi
Can we have clustered index on a column which has duplicte values?
Regards
Nitin

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-05-03 : 18:26:41
Do you have SQL Server Books Online on your computer? Have you tried looking up the answer prior to posting a question?

Tara Kizer
aka tduggan
Go to Top of Page

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-05-03 : 19:43:12
Tara
Just got my system reinstalled.Sql Server will be installed today.
I think the answer is no.Am i correct?
Regards
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-05-04 : 03:59:51
No, you are not correct, but its generally a bad idea. The details are in BoL as Tara said.

Kristen
Go to Top of Page
   

- Advertisement -