I still don't understand why you would do this, but you might want to look up the SQL Agent in the Books Online.

If you look at the execution plan for the DISTINCT, you're getting a huge load because of the DISTINCT operation itself. It's joining ALL the data between the three tables...

Yeah, Gail's got it. Fix that lookup operation with the included columns and should see a pretty substantial increase in performance.

I think you're getting those scans because of the...

That looks like SQL SErver 2000. You're posting in the SQL SErver 2005 forum. There is a difference in functionality. That's why you can't save the plan.

Well, without the data...

The problem is, especially when dealing with...

GilaMonster (2/19/2009)

---

Lynn Pettis (2/19/2009)

---

Talking about interviewing, I would love to be in the same place at the same time as Jeff, Gail, Grant, Gus, Matt, and Jack and have a...

You generate an actual execution plan, graphical is fine, even preferred. Right click on...

GilaMonster (2/19/2009)

---

Depends what I'm interviewing for. If I'm interviewing someone for a senior position where they are expected to pull their weight immediately then a certain level of knowledge is...

OK. This is going to lead to table scans:

WHERE R.MedGroupID = ISNULL(@MedGroupID,

...

That's kind of a wide PK, depending on the data types. Can you post the execution plan? Actual please, not estimated.

I'm still trying to untangle the code (did you really need to put comments at the end of every line?), but if this is functional as an inline UDF, then...

Lynn Pettis (2/19/2009)

---

Talking about interviewing, I would love to be in the same place at the same time as Jeff, Gail, Grant, Gus, Matt, and Jack and have a mock...

What is it that you're actually trying to do?

Just so you know, the code you posted ran in 89ms on my desktop (not the fastest machine on earth either).

It sounds like the database is in FULL recovery mode. So you need to institute log backups. Depending on your data needs, you could set the database to SIMPLE recovery...

harsha.bhagat1 (2/19/2009)

---

Hi all,

I have a procedure which has to insert into a table in different database and then will delete those data from the related tables. There are more than...