Posted by --CELKO-- on 11/28/07 16:11

>> Then all is well, well it would have been if they are started out properly in the first place [NOT NULL UNIQUE on natural key]. <<

This should be a no-op, but it scrambles everything

BEGIN
DELETE FROM Foo
WHERE server_name = 'server_bob';
INSERT INTO Foo VALUES ('server_bob');
END;

And you added the cost of an extra index with the UNIQUE, too!

• Next in forum: Re: Data insertion too too slow...
• Prev in forum: Re: many "or" operation make system choose incorrect index
• Thread view: Re: SQL Express - Identity specification property - how to change

[Reply to this message]