And everywhere else.

Steve Jones - Editor (2/19/2009)

---

A group interview could be fun. Round robin style, ask each other questions. I'd tape it, maybe cut down to some interesting answers for a podcast.

Grant,...

There are a bunch of functions available in the Scripts area of the site. You do a search to track them down. Here's the one at the top of the...

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...