The 2nd Monitor

« first day (405 days earlier) ← previous day next day → last day (3612 days later) »

Mat's Mug

9:01 PM

Oh, and I just resigned! (driving, will be back later)

Phrancis

Just finished writing my SQL script with 2 CTEs, will post it tonight to CR yay!

Captain Obvious

9:15 PM

Q: compairing 2 lists of peptide to spectrum rankings generated bij 2 difrent algoritms

I would like to get some feedback on my coding style or other remarks that can be made. This program gets 2 lists of peptide to spectrum matches, so evry spectrum title is linked to a list of 1 or 10 posible peptides and this program checks for occurance on both lists and if they do occur on bot...

java

Dagg Nabbit

Jamal

@CaptainObvious That's a lot of spelling errors.

Dagg Nabbit

who removed the comments from this question: codereview.stackexchange.com/questions/54059

the comments pointed out things that were broken

the comments were removed and the question reopened with things still broken

the question was answered, the answer points out the broken things

the question should never have been reopened as it was broken correct?

Jamal

They were removed after the question was reopened. Many of them were noisy as well.

Dagg Nabbit

my initial comment pointed out two broken things

one was fixed

one was not

OP wanted it reopened but never addressed second broken thing

as you can see from answer...

> in your example, jqueryButton is a jQuery object, so you can't do jqueryButton.href. If you want to access the href property, use the prop() method:

it was broken

this was mentioned in my comment that is now deleted, and never addressed by OP

idk what the sequence of events here was but i assume that with comments removed it was no longer obvious that it was broken

so people reopened it

Jamal

9:21 PM

Again, they were removed after the question was reopened, not before.

Dagg Nabbit

ok. so can someone explain the topicality of broken questions to me

why are we reopening them

and answering them

ckuhn203

simple mistake? Someone didn't read the comments?

Dagg Nabbit

there was also discussion about it here

ckuhn203

Dang. @Jamal caught the period I missed.

Dagg Nabbit

ugh

ckuhn203

9:27 PM

Not all of us chill on 2nd monitor. There are other users...

It sucks. Vote to close it. Move on.

Dagg Nabbit

three of the 5 reopeners are regulars here

i cant

ckuhn203

Oh.

Dagg Nabbit

i already vtc'd

seriously, if we entertain that kind of garbage here what makes us any better than SO?

ckuhn203

Now I see why you're upset.

Nothing.

Some people didn't seem to agree with me earlier about some hypothetical code too.

I think it did eventually get closed too though.

Jamal

You may also argue your point on Meta. Not everyone will see it here, especially as it gets pushed back by other discussions.

ckuhn203

9:31 PM

^^TS

ttgh

skiwi

Gooooooooooooooooooooooooooooooooal! x5

Phrancis

SQL ORDER BY always goes at the very end of a SELECT right?

Simon André Forsberg

@DaggNabbit A "problem" with the question is that he doesn't seem to be aware of the brokenness. The question asks for how it can be done cleaner, not for how to fix a problem with the code. I remember seeing that question in the re-open queue and pressing "skip" on it, because I couldn't tell if the code had been fixed or not.

Once a question that was closed for not having working code is edited with modifications to the code, it is easy to assume that the code has been corrected.

200_success

@Phrancis COUNT(*) is fast on MySQL MyISAM tables. It's slow on InnoDB and PostgreSQL.

Phrancis

What about MS SQL Server?

Simon André Forsberg

9:39 PM

@skiwi Football, I assume?

Dagg Nabbit

@SimonAndréForsberg it should not be easy to assume that when there is a comment indicating brokenness that has not been addressed by the change

@Phrancis after the WHERE clause

but before stuff like LIMIT

Phrancis

After HAVING right?

Simon André Forsberg

@DaggNabbit True indeed. If your comment wouldn't have been there, I would probably have voted to re-open the question.

200_success

@Phrancis This implies that COUNT(*) is slow on SQL Server.

Q: What can speed up a SQL count query?

When doing a count (aggregate) SQL query, what can speed up the execution time in these 3 database systems? I'm sure many things could speed it up (hardware for one), but I'm just a novice DBA, so I'm sure I'll be getting a few answers here. I migrated about 157 million rows to a SQL Server dat...

sql-server query-performance count netezza

Dagg Nabbit

@Phrancis having goes after group by

Phrancis

9:44 PM

What I'm writing is:

SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

I feel pretty safe in saying this is right just wanted a 2nd opinion :)

Dagg Nabbit

yeah that looks right :)

@Jamal apparently there is nothing to argue; I thought it had been reopened as a result of the comments being removed but if that's not the case there's nothing that can be done... assuming people realize broken stuff is OT, the problem is just that people can't identify broken stuff and vote to reopen based on their inability to assess the code properly

always going to be a problem where subject matter has low barrier to entry

this is why i miss pre-google-groups usenet

even if subject matter had low barrier to entry, the actual vehicle for discussion had reasonably high barrier to entry and you mostly got high-quality stuff to look at

Captain Obvious

Q: JavaScript: Google Analytics tracking code

I don't know much about JavaScript. But it would be great if someone could explain me what the code by GoogleAnalytics does that you paste on your website. A line by line explaination would be great. <script type="text/javascript"> var _gaq = _gaq || []; _gaq.push(['_setAccount'...

javascript

Corbin

10:01 PM

Is there a way and is it encouraged to report serial minor-editors?

Someone edited a 2 year old post of mine to add 2 characters (that didn't even change anything). His history is full of page after page of tiny edit, and I believe it to be an attempt to game the system, not a bad case of OCD.

Phrancis

DELETE FROM Work WHERE User = 'Phrancis';

Bye y'all

Corbin

Bye, Phrancis

Jamal

@Corbin You might have to flag one of their posts.

Simon André Forsberg

10:29 PM

@Corbin Such edits should be rejected as too minor. Or does the user already have full editing privileges?

@Corbin If it was @Malachi who did it, then he probably will stop now that he has the Copy Editor badge :)

Corbin

He has full editing privs.... It's a user on SO.

Captain Obvious

Q: How can I optimize this SQL ranking generator query?

So I have a World Cup fixture app where people can guess the results of the matches. Everything is working great but each time I update the ranking it takes 20 minutes for just 3000 users. So there must be something really wrong with this. These are the tables being used: Users CREATE TABLE `u...

optimization refactoring sql mysql

Corbin

Idk... I probably won't pursue it. Most of the edits are arguable... It's just about 20% of them that are obviously trivial with 60% most likely trivial.

Jeroen Vannevel

custom flag it for a moderator

Corbin

10:47 PM

Yeah, I might should. Definitely seems to be someone gaming for a badge :/

Malachi

11:37 PM

@SimonAndréForsberg what are you talking about. I try to only make edits if they add the the quality of the post, and are more than at the least 6 characters

was it me?

Corbin

11:58 PM

It wasn't haha. Don't worry; it was someone on SO with a history of about 500 edits with very, very few questions/answers. (Not that mostly editing has anything wrong with it -- it's just minor edits make the lack of questions/answers suspicious :p)

Malachi

@Corbin Agreed

I have plenty of Questions and answers here

not so many on SO