Re: index

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Sorry to hijack, but Dan, Erland.... can you elaborate more
please! :o)

I always took it to mean that a clustered index was unique and did not
allow duplicate values to be entered wether you specified unique or
not. Most of the DB clustered indexes I've had experience using/
creating etc have all been primary keys using an identity field on an
INT/BigINT data type depending on the use so would never want these to
have a duplicate value in there.

I presume this might be if you have identity inserts allowed? I'm also
presuming a Primary Key would also fill the role of the unique keyword
as well when creating tables etc from T-SQL code/scripts and as such
this would only relate to clustered indexes not set as the primary key
of a table?

Hopefully I'm not barking completely up the wrong tree!!!
Thanks,
Scho
.

Relevant Pages

  • Re: index
    ... But the index created by the primary key does not have to be a clustered index. ... It is true that if you define a primary key on a table that does not already have a clustered index, the primary key becomes the clustered index by default. ... creating etc have all been primary keys using an identity field on an ... I presume this might be if you have identity inserts allowed? ...
    (microsoft.public.sqlserver.programming)
  • Re: converting log file to db table
    ... Whether you use an IDENTITY field or some ... Primary Key based on your fields does not matter ... If you already know what ID3 ... I suppose you want to test your software by loading data the ...
    (microsoft.public.sqlserver.programming)
  • Re: Replication Fails With Violation of PRIMARY KEY constraint
    ... I am using transactional replication. ... CustomerInformation has an identity field as its primary key, ... On the third subscriber, which was working fine, whenever I ...
    (microsoft.public.sqlserver.replication)
  • Clustered Indexes / Primary Key
    ... The first thing I have run into is Clustered Indexes not sorted. ... The Cat. ... No. is the Primary Key, Clustered, Unique, No-Nulls. ... Just learning SQL Server. ...
    (microsoft.public.sqlserver.odbc)
  • Re: http_referer
    ... >database has a Primary Key that is an identity field (autonumber). ... >If I submit the form it inserts the record, if I refresh the insert page ...
    (microsoft.public.inetserver.asp.db)