Re: Indexes and primary keys, from Delaney

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

From: DW (None)
Date: 03/04/04 

Date: Thu, 04 Mar 2004 13:40:53 -0800

One comment:

"Kalen Delaney" <replies@public_newsgroups.com> wrote in
news:#k25rmdAEHA.3220@TK2MSFTNGP10.phx.gbl:

> It is meaningless to say that you want a Unique Constraint (or PK
> constraint) but that the index is unnecessary. It is the index that
> allows SQL Server to guarantee the uniqueness.

That wasn't 100% clear from the books I had read (including yours!!). Now
it is completely clear. Thanks.

David Walker

Relevant Pages

  • Re: Table Design Advice
    ... I will be creating db in SQL server though. ... MaterialCost (Currency) ... CONSTRAINT pk_products PRIMARY KEY, ...
    (microsoft.public.sqlserver.setup)
  • Re: Sequential Number in an Update
    ... And just how the hell are you going to put that in a CONSTRAINT using ... parser for grepto SQL Server dialect, but I cannot find it on my ... It probably should be re-done with CASE expressions. ... syntactically correct URL) and verification (This URL actually belongs ...
    (comp.databases.ms-sqlserver)
  • Re: How to handle constraint errors programmatically?
    ... errors for this situation (i.e. a constraint violation). ... >> I've got relational constraints setup in my SQL server database. ... can't delete a customer who has orders. ...
    (microsoft.public.access.adp.sqlserver)
  • RE: ORDER BY and IDENTITY
    ... SQL Server does guarantee the order of the result set based on the ORDER BY ... direction used to create the clustered index. ... > resulting in the Sort operation happening before the Compute Scalar ...
    (microsoft.public.sqlserver.programming)
  • Re: Table Design Advice
    ... Are you sure you are using SQL Server? ... CONSTRAINT pk_products PRIMARY KEY, ...
    (microsoft.public.sqlserver.setup)