I'd have to say it falls into it depends. I don't mind reading a bit, but sometimes people post several hundred lines of code and, quite frankly, I don't want...

That sure sounds like a pretty standard INNER JOIN.

Try this:

CREATE TABLE #Parent

(ParentId INT IDENTITY(1,1) NOT NULL

,Val NVARCHAR(50) NOT NULL

,CONSTRAINT pkParent PRIMARY KEY CLUSTERED (ParentId))

CREATE TABLE #Child

(ChildId INT IDENTITY(1,1) NOT NULL

,ChildVal...

DISTINCT is killing your peformance. You should try to find away around it. Plus, from the execution plan provided, it was five rows going in and five rows coming out....

If your page life expectancy is high, there's not to do but sip some coffee and look for other causes of poor performance. A high page life means that the...

Someone or some process such as a SQL Agent job must be switching it to simple recovery. I'm not aware of anything that does it automatically in the background.

Which model...

Darn. And I'm hungry too. Ah well. Life is full of these little disappointments.

First round of scotch is on me!

I agree with the others but feel the need to express it a different way.

If you're simply learning SQL Server, no. It's conceptually beyond the basics a bit.

If you're using...

I think my issue with doing it the "interesting" way as opposed to using JOINs is that, while this time, the performance and plan is likely to be identical, far...

Jeff Moden (4/11/2009)

---

Well... I did it. Thank goodness they extended the deadline of PASS 2009 Session Abstracts. I'll be there one way or another this year.

I...

radek (4/11/2009)

---

Hi,

really you need all columns (*)

So you can create nonclustered index on macaddress is key of index and this index will have inlcude other colums, try this....

I used to use it for error handling back in SQL Server 6.5 & 7.0. But I came out of the VB coding camp back then, so I did lots...

It sounds like you've set up the maintenance jobs or the sql agent, or both, to run under the 'sa' login and the password is not correct. Try running under...

I'm afraid I don't understand the question. Are you concerned that your system is not using enough memory or too much?

One measure that will tell you if memory is a...

kim.talley (4/10/2009)

---

I have a question from a developer that I'm not able to answer....I was hoping someone here could help out.

Is it more efficient to use multiple joins in a...

It really could be almost anything. Since you don't know, you need to investigate systematically. I like the recommendation to capture a trace. That's something I always do. I'd also...