credenza

Nice article. Thanks for taking the time to write it and share it with us.

That is part of the beauty of this query.

😀

Whisper9999 (3/6/2010)

---

Jeff Moden (3/6/2010)

---

Whisper9999 (3/5/2010)

---

Are there any decent and legitimate jobs out there that are parttime and let you keep your "day job"? I'd like to work a little...

RBarryYoung (3/6/2010)

---

GilaMonster (3/6/2010)

---

RBarryYoung (3/6/2010)

---

Joins are not "better" than sub-queries. They are not even "in general" better than subqueries. They are "in general" about the same thing, but it...

iamthemanx (3/6/2010)

---

That would be awesome for you!!!! Showing you're proficient on both...

My wife and I recently had this same conversation. If I were the Boss, would I allow somebody to work for me while impaired. The answer was no....

waffle

Paraffin

You're welcome.

Once again, very interesting. Checking this last one out, and it seems very similar in speed to the other "fastest" ones submitted. Good job on coming up with...

I would be careful on the sort transformation. Many times a sort transformation is necessary when using a merge join...

Sure somebody here could help, if you post the actual query or question.

This article might be useful for you.

http://www.mssqltips.com/tip.asp?tip=1571

Some reading first:

http://msdn.microsoft.com/en-us/library/cc966412.aspx

Some perfmon stats to look at

Average Disk Seconds/Read

Average Disk Seconds/write

Each of those should be under 10ms for good, between 10-20ms is average,and over 50ms is bad.

Another perfmon stat

Avg....