Re: Update question

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 01/07/05 

Date: Fri, 07 Jan 2005 15:41:43 +0100

On Fri, 7 Jan 2005 14:42:45 +0100, simon wrote:

(snip)
>So, when use table without PK? Is that allowed?

Hi Simon,

Yes, it is allowed by SQL Server, though it is on violation of relational
rules. It is definitely NOT a good practice, though, and I suggest you to
identify and define the key for that table as soon as possible.

>Why ITW recomends nonclustered index before clustered? I thought, first
>should be PK and than I can build all other indexes.

I have no idea - I already told you my experience with ITW is very
limited.

Please ask in a new post. It'll be of help to anyone who'll try to answer
your post if you include the table structure (www.aspfaq.com/5006) and the
query you're trying to optimize. Some sample data (as INSERT statements)
would be nice as well.

Best, Hugo 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)

Relevant Pages

  • Re: UPDATE Statements May be Replicated as DELETE/INSERT Pairs
    ... Looking for a SQL Server replication book? ... the delete that SQL server sends will cause a foreign key violation? ... Delete/Insert pairs, I was really surprised and couldn't understand ...
    (microsoft.public.sqlserver.replication)
  • Re: bible says all catholics and religious people are all KOOKS
    ... <snip meaningless quote which is incongruous with Mawhorra's behavior> ... > If you want to believe that Christianity is some George Orwell ... Simon is real. ... <snip more delusions> ...
    (alt.religion.christian.roman-catholic)
  • Re: multiple cascade paths
    ... I'll address some and snip the rest of the post. ... The only reason to go to SQL Server now is because right ... cascading deletes in some other way. ... most foreign key constraints don't form cycles or multiple cascade ...
    (comp.databases.ms-sqlserver)
  • Re: Shit was [shit]
    ... Of course Simon and the other Rowland-haters can't admit that I might ... arrogant or anything - you're totally lacking in self-awareness, ... You want me, a seriously mentally ill person, to kill himself through ...
    (uk.people.support.depression)
  • Re: EXECUTING SP
    ... Tibor Karaszi, SQL Server MVP ... "simon" wrote in message ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)