The foreign key constraint can do it for you. Look up "FOREIGN KEY" and "ON DELETE CASCADE" in BOL.

Tara-1044200 (6/16/2010)

---

I have database with 6 yrs of data and now i am splitting that into 2 different database's having 3yrs of data in each because we use only latest...

You have to wite it as SELECT @variable = Field:

select @user-id = USerID where firstname = (SELECT SUBSTRING(@@UserName, 1, CHARINDEX(' ', @@UserName) - 1))

...

Do we work for the same company?...

It does, indeed. The point is that many employers want their employees to sign NDAs or non-compete, but they don't know that this has to be explicitly paid. If those...

Your query hasn't changed, but maybe data did.

Are data volumes the same?

Are statistics up to date?

There's lots of things you could look into, I just named the first ones that...

Drop the primary key, or add to it all the fields that actually make up the key, if this applies.

Is there a better primary key fo that table?

Steve-3_5_7_9 (6/16/2010)

---

GilaMonster (6/16/2010)

---

Steve-3_5_7_9 (6/16/2010)

---

Actually, this makes a lot of sense. Sometimes it is difficult to terminate someone, especially if they have great performance reviews, so having a NDA on...

Great! "I can't change the query, but, please, make it go faster!"

Totally different subject: I get 1 notification every 10 or 20 posts on THE THREAD.

Are you experiencing the same?

Maybe too many people subscribed.

Paul White NZ (6/16/2010)

---

We scored a goal and drew!!!!

WOOT!

:w00t:

Thanks to everyone that posted congratulations. 🙂

I'm thinking Italy should be no problem now. Do they even play football/soccer over there...

Jeff Moden (6/15/2010)

---

CirquedeSQLeil (6/14/2010)

---

It seemed to me that the argument was coming from one side today. It appeared that...

scott.pletcher (6/15/2010)

---

Jeff, you can over-engineer, I'll give you that. Huge amounts of wasted I/O to no purpose. But you feel good about it, and obviously for you that's...

Paul White NZ (6/15/2010)

---

Thanks Jan, I think we're just...

Well done on the "Mentor" thread, Gail.

Hope he stops.