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

Site Visits Results

Summary

Three tests were run with different methods of calculating site visits.

1. Using a normal cursor - jacroberts

This took 29:36 to complete

2. Using a "pseudo" cursor - Jeff...

TheSQLGuru (1/5/2009)

---

jacroberts, I imagine this query may be succeptible to parameter sniffing due to the where clause. Well, that assumes there is an index that is useful here and...

The first bit of testing is finished. Firstly I am just testing the different initial queries to get the data. So no results from the cursors yet. I've had to...

Matt Whitfield (1/3/2009)

---

@jacroberts - can you include that last one in your test runs monday? I know it's cheating, but I think coming up with the best performing solution is...