--- duplicate ---

--- duplicate ---

Bob,

Good point - though you can add 'WITH TIES' to my TOP (1)...

Paul

Heh - because the whole thing was kinda jokey - a bit of fun for an otherwise fairly tedious Monday at work.

I agree with what you say about the quirkiness...

For larger tables, with a useful index on endDate, this may be even faster than the ROW_NUMBER version:

SELECT TOP (1)

T1.endDate,

...

There is an interesting case where this isn't true (though...

As Barry said, a ROLLBACK undoes all changes - including the actions performed by the trigger.

You can do imaginative stuff with table variables, but I'm not going down that track...

The redoubtable G² has two SSC articles on auditing which you may find rather interesting:

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

Paul

Jeff Moden (5/17/2009)

---

.. if, for some reason, you cannot use IDENTITY and you're stuck with SQL Server 2000 or less which prevents the use of ROW_NUMBER and the like, then...

In case you guys think I'm cheating by changing the nullability of the id column, this version is a true replacement, and is just as fast:

SET NOCOUNT ON;

-- Conditional drops

IF...

Hey Jeff & Flo,

Just a couple of things... 🙂

1. This isn't a true 'quirky' update unless there's a clustered index to determine the order of the ID assignment. ...

Also check that you are trying to connect using a protocol that the server is listening on (named pipes or TCP/IP).

It would be good to see some example code for this one.

I wonder if shared (global) temporary tables are being used...? (Just one possible cause from many)

Marcin Gol [SQL Server MVP] (9/6/2009)

---

exec [dbo].[sp_BackupAllFull]

@MarkName nvarchar(8),

@BackupPath nvarchar(128),

@TimeStamp datetime = NULL,

@UseLocalTime bit=0

if you are trying to pass less parameters then procedure require and you omit...

A great approach to performance optimization can be found in the following TechNet article (waits and queues):

It gives great detailed advice and includes scripts and other goodies. I recommend...