Well done, and thanks for sharing.

Jeff Moden (10/7/2010)

---

Man... well done. Just don't ever put something like this in a transaction... it will cause deadlocks in the "outside" world. Also, make the code handle...

I think this should do:

DECLARE @searchDate datetime

SET @searchDate = '1985-03-26'

SET @searchDate = DATEADD(day,DAY(@searchDate)-1,DATEADD(month, MONTH(@searchDate)-1, 0))

SELECT *

FROM astrology atr,

store_dob...

Very strange. It's a question I don't see very often and we got two today.

Here's the other one.

hahnorlaska (10/7/2010)

---

The attached show plan statistics outputs gives detailed information on what was being done to process the query (the physical operator. logical operator, argument, objects involved (indexes), row counts,...

Probably your logging procedure was rolled back by an outer transaction.

Try using db mail.

... ok, it was me! 🙂

Is it me or there's a better way to describe this problem?

I don't think I understand what you're after.

Can you explain?

You could start from the EXCEPT, that generally involves a SORT DISTINCT on the two inputs.

I think you should calculate the output field AFTER the except.

As a side suggestion, nobody...

Oracle RAC stands for Real Application Cluster, that is an...

I don't think it can be done.

When you run a query in multi-server mode, the query is run on each connected server and the results are merged by SSMS.

Issuing SELECT...

You could use db mail to send an alert to your mailbox.

For some reason I feel that this is not exactly what you want. Can you elaborate a bit more?

grahamc (10/7/2010)

---

Something worth looking at is "write cache" on the SAN... I have had the same in the past where all-of-a-sudden performance falls through the floor (in a very bad...

Nobody can acces the row while you're updating it.

Don't worry about that.

It could be something like this:

CREATE PROCEDURE [getSequence]

AS

BEGIN

SET NOCOUNT ON

DECLARE @newVal int

BEGIN TRY

BEGIN TRAN

UPDATE SequenceTable

SET @newVal = Sequence = Sequence + 1

COMMIT

END TRY

BEGIN CATCH

DECLARE @ErrorMessage NVARCHAR(4000);

DECLARE @ErrorSeverity INT;

DECLARE @ErrorState INT;

SELECT...