I have couple other recommendations that might help as well. I'd code this something like this:

IF EXISTS(Select 1 From Inventory where FlightNumber='F3241b' AND total >= sold + 1)

...

You could use a an UPDLOCK table hint on the select statement or you could use SERIALIZABLE as the Isolation LEVEL. I honestly don't know which one will work...

You mean something like this:

SELECT

OBJECT_NAME(I.object_id) AS table_name,

I.name AS index_name,

...

When connected to the SQL Server on the copy, what does SELECT @@SERVERNAME return?

Check out this article, http://msdn.microsoft.com/en-us/library/ms143799.aspx

Can you be more specific?

What do you mean by "it was not migrated full database"? Does that mean that you were missing data or that you need to migrate...

Sure there are lots of things that can cause this:

Blocking

Other processes running on the server

Having to go to disk instead of memory to retrieve the data

Network latency

A better measure of...

Return values are rarely used to determine the status of a stored procedures execution. Normally you will either let the error bubble up to the client or handle the...

Grant Fritchey (3/15/2012)

---

Jack Corbett (3/15/2012)

---

herladygeekedness (3/15/2012)

---

I have also lost jobs on terminology as I am also self-taught. I'm more a data analyst/programmer than DBA but around SQL...

jcrawf02 (3/15/2012)

---

Agree with disagreeing about calling it "poisonous", but don't quite agree with your wording Jack. Hate to say that a "wife can distract you", I see it more as...

herladygeekedness (3/15/2012)

---

I have also lost jobs on terminology as I am also self-taught. I'm more a data analyst/programmer than DBA but around SQL since 6.5 and recordsets from same...

L' Eomot Inversé (3/15/2012)

---

... all started off by Paul's poisonous attitude, not a sudden decision on the grounds that inherited parishes and sees were a bad thing.

Paul's anti-marriage poison (which...

What about storage? What changed?

Wait, that was done in southern California, does that really...

Have you checked index fragmentation? Have you updated statistics?

How many CPUs/cores on the new box?

Can you see what happens if you set MAXDOP = 1 to the query? ...

Joe,

I believe the OP needs a view that shows both PL and BS amounts in YTD, but the calculation is only needed for the PL amounts. Also, the OP...