SQL Noob (10/7/2009)

---

i have a database where i dump logs into from 50 or so domain controllers, sql servers and other servers. each server has one or more tables. to...

Charles Kincaid (10/7/2009)

---

Chris,

Not exactly. The UNION / UNION ALL is kind of tough one to get wrapped around. UNION ALL combines two or more identically structured result...

SQL Noob (10/7/2009)

---

is there any performance difference doing a union all compared to a join when you need to get all the rows from two or more tables? i have...

Excellent article.

You mentioned not knowing a real world application of the CROSS JOIN.

In my experience, this is typically used for creating test data.

Sometimes you need to test data in all...

jaxcitytech (11/14/2008)

---

I've been struggling lately with nagging feelings of dishonesty for charging for a full 8-hour day on days I didn't feel were 100% productive (progress I could prove every...

Hey Steve,

Thank you for posting this poll.

There are so many people I wanted to quote here and I probably will refer back to this page often for so many of...

K. Brian Kelley (11/13/2008)

---

Also, to maximize the effectiveness of Twitter, you really need to get one of the clients that makes use of the Twitter APIs. The web interface presented...

Hey Steve,

In your article, you said

I've been using Twitter for about 4 or 5 months now and it's one of those things that I'm not sure of the benefit of...

brewmanz (10/13/2008)

---

Please don't tell my daughter. I take great delight in proofreading her work and finding mistakes (she works for a brochure publishing company). Sadly, it seems that I am...

brewmanz (10/13/2008)

---

The declarations were not intended to confuse;...

Were the declarations of @SumA and @SumB supposed to confuse us on this one? I found them to be completely unnecessary.

Thanks for posting. I have often found SQL calculations...

I've followed conventions such as those mentioned in this post, and from an organization perspective, it makes sense.

However, I read somewhere, and please correct me if I'm wrong, that...

Japie Botma (1/17/2006)

---

I have used this method for years (because I hate cursors), but does it slightly different. I use a #Temp table and then select the TOP 1 at...

I have been in similar situations.

Sometimes, for instance, the application is set to support more than one business unit or entity and those units may share a number of...

Ryan Riley (5/15/2008)

---

sadara (5/15/2008)

---

i disagree. if the programmer can't communcate well with at least the person/people supplying him/her with the spec, s/he will quite likely code what s/he THINKS is...