re: A request of the tigerdroppings DBAs

Any calculations that don’t have him as the clear #1 are inherently flawed.

quote:

---

Hammertime's "Check His Knuckles First" thread had over 1,200 downvotes. It occasionally gets bumped, so new downvoters can add to the tally.

---

A truly amazing thread. Last time it was bumped I think it had about 2400 downvotes.

quote:

---

SELECT TOP 5 Poster, COUNT(*) as CNT
FROM VoteTable
WHERE VoteType = 'UP'
GROUP BY Poster
ORDER BY 2 DESC

---

Sigh. With all the bad grammar on this board I'll have to call you out on this too. Since "TOP 5" is a SQL Server construct I'll assume you aren't using Oracle.

That said, it's bad form to write this:

quote:

---

ORDER BY 2

---

Instead, explicitly name the column;

quote:

---

ORDER BY COUNT(*)

---

This improves readability plus it removes the possibility of miscounting the column number.

“Johnny Jones is not the problem” thread on the rant got over 500 in a little over an hour.

This

quote:

---

would return the top 5 most upvoted and downvoted posters.

---

would be more interesting than this

quote:

---

OP asked for most upvoted and downvoted POSTS.

---

quote:

---

You probably will have to incorporate some table joins baw. Surely TDs database isn't that flat.

---

Votes seem to be a CSS feature and probably aren’t stored anyway, so this is just a thought exercise. Which the poster you quoted did not pass.

It's one big jsonb field

quote:

---

Chicken probably needs to do an index evaluation or invest in an all flash array

---

It's almost certainly some VM's behind AWS or Azure.