---

11. More WHERE clause hints - Avoid unnecessary conditions in the WHERE Clause. Also try to avoid a function in the WHERE clause as it presents SQL engine to do...

---

10. WHERE clauses - In a WHERE clause, the various operators used directly affect how fast a query can run. Here are the conditional operators used in the WHERE clause,...

Thought I'd get in with the first comment, only a spelling mistake that gets through a spell checker:

Update: I would recommend you to use SET NOCOUNT ON for the shake...

GSquared (8/13/2009)

---

jacroberts (8/13/2009)

---

GilaMonster (8/13/2009)

---

Plus who decides what's right? The last editor? What happens if someone comes along a couple months after an article's been published and edits garbage in. It...

Andy DBA (8/13/2009)

---

John te Lintelo (8/11/2009)

---

Andy DBA (8/10/2009)

---

So my question is: Does anyone have strong recommendations (other than readability:-D) regarding LEFT JOIN versus either of the other two? Are...

GilaMonster (8/13/2009)

---

Plus who decides what's right? The last editor? What happens if someone comes along a couple months after an article's been published and edits garbage in. It may go...

If the the site implemented Wiki, users could go in and correct any errors on the articles?

That way the site could host a set of excellent, up to date, well...

Kit G (8/11/2009)

---

jacroberts (8/11/2009)

---

I feel that's fine as a policy but there is no warning of this within the articles, they can look like they've been reviewed and properly published...

I feel that's fine as a policy but there is no warning of this within the articles, they can look like they've been reviewed and properly published when as no...

Lynn Pettis (8/10/2009)

---

LP (8/10/2009)

---

Absolutely agreed. Very dangerous article espesially for...

Lynn Pettis (8/10/2009)

---

Tim Walker (8/10/2009)

---

Lynn Pettis (8/10/2009)

---

oli (8/10/2009)

---

Paul White (8/10/2009)

---

I deeply begrudge the minimum one star.

Gail's first post expresses it best, and in milder language terms than I might have...

GilaMonster (8/10/2009)

---

rja.carnegie (8/10/2009)

---

... because it's no longer the case that your use of the command has to be considered as possibly "SELECT column FROM gregory.table" and mine is "SELECT column...

ronmoses (8/10/2009)

---

10. WHERE clauses - In a WHERE clause, the various operators used directly affect how fast a query can run. Here are the conditional operators used in the WHERE...

Unless you are one of these:

http://www.youtube.com/watch?v=9nNGlaiVypU

http://www.youtube.com/watch?v=XooTrS440Us

Matt Whitfield (1/9/2009)

---

So, collectively we fixed a logic funny for you, and made it quicker to boot.

Go team! 😛

Ultimate props to Jeff on this one - I think the...