Question here:

Why is this query slow the first time after I start the service?

tl;dr: After about an hour, someone swung by and started editing and answering and whatnot, as one does. Pretty immediately after that, Bill the Lizard summarily insta-deleted the whole thing, no reason given.

I only saw this just now, about four hours after posting, having had other matters to attend to and previously having experienced that one often doesn't get much by then anyway.

Can someone shed some light on why my question was banished by the fist of an angry god?

Further info for us sub-10K plebs: it was a question about very puzzling SQL Server query behavior and how to iron it out.

  • 6
    While the question itself isn't a great question, I don't see anything glaringly wrong with it that would cause a mod to insta-delete it. So either it was a mistake or there's something going on behind the scenes that I can't see. – Mysticial Nov 23 '13 at 2:19
  • 2
    Yeah, this looks like an honest mistake. I'm sure a mod will look into it shortly – Pekka supports GoFundMonica Nov 23 '13 at 2:27
  • 5
    The only thing I can see is that maybe it's because of the cursing. This is supposed to be a professional resource of knowledge, not a place to vent. With that said, I wouldn't have outright deleted your post as it wasn't that bad; I would have instead just fixed the title and edited the first sentence to clean it up and then left a comment letting you know why I edited. – jmort253 Nov 23 '13 at 2:32
  • 9
    "Why the hell does this SQL Server query run forever the first time [...]" | "What the hell is going on here?" – Felix Nov 23 '13 at 2:37
  • 6
    Yes... cursing... I mean, we talk like that at work sometimes when it's just a few close colleagues... but that's the difference between the spoken word, something that fades away quickly, versus the published word, which thousands of future visitors would see for years to come... – jmort253 Nov 23 '13 at 2:41
  • 5
    I was unaware the denizens of this fine establishment were of such tender sensibilities as to deem that particular epithet for the underworld so antithetical to proper discourse. Ahem. – Atario Nov 23 '13 at 2:44
  • 2
    lol, well, again, what we do offline, (or in the C++ Lounge chat room), is much different than how we want to present Stack Overflow to the world. :D – jmort253 Nov 23 '13 at 2:49
  • 6
    Keep in mind, @atario, that only the first line or so of a question (combined with its title) are shown in the normal questions lists and moderator queues. And you managed to make both of these read as though you'd written a rant instead of a question. Lesson learned, I hope. – Shog9 Nov 23 '13 at 2:51
  • 2
    @Atario - Big difference there.. come on, surely you recognize that language is a slimy beast – Adel Nov 23 '13 at 3:06
  • 8
    @Atario: yes, absolutely. Not saying that's what happened in this case - I can't know - but, yeah, all the time. Wasting time on page-loads for spam, non-answers and assorted noise is not really practical on a site the size of Stack Overflow. If you start off your question with "Full Movies Streaming Live HD" it would probably be deleted unread as well. – Shog9 Nov 23 '13 at 3:16
  • 3
    @Atario: Not saying looking for explanation/solution is wrong. I'm saying the way you asked the question made it appear more like a rant than an explanation/solution question. There's a vast difference between "WTF? This is #&$&@^ BS!!!" and "Can someone help me understand?" are pretty clear. If you ask your question in a clear fashion instead of resorting to the rhetoric and noise, it's more clear that you're asking an actual, technical question instead of just complaining about something. SO is supposed to be a technical site - don't be surprised if rant-like posts get unexpectedly closed. – Ken White Nov 23 '13 at 3:39
  • 6
    Look man, we're all just trying to help you here. The question shouldn't have been deleted - it was edited and restored. But if we didn't try to convince you to leave off the noise, we'd just end up back here in another month doing this again - no one wants that. – Shog9 Nov 23 '13 at 4:16
  • 2
    @Atario: No, that's not what I'm saying at all. :-) I agree that someone read it, wrongly thought it was offensive, and flagged it, and it was deleted as a result. I'm also saying that, when I look at the original question, I would have voted to close it as a rant instead of a question. I didn't find it offensive, but it appears like a venting session for the most part. The constructive part is that maybe if you phrase your questions differently, that erroneous flag (or the close vote I would have made) might be avoided in the future. – Ken White Nov 23 '13 at 4:43
  • 9
    @Atario: No, you're not overinterpreting anything. Appears to be is the relevant information. If you write what appears to be a rant, it will most likely be closed/downvoted. Your task is to write a question that does not appear to be a rant. If you ask a question that is clearly a question, it won't be confusing to everyone else. Again, I don't know how to state this more clearly. If you write what looks like a rant, reads like a rant, and then narrowly avoids being a rant at the end, it will probably appear to be a rant to those who read it. – Ken White Nov 23 '13 at 5:31
  • 2
    @Atario Reading through this: you're misunderstanding what people are communicating (occasionally quite profoundly). You are also being fairly hostile. I strongly suggest you leave this be for now and come back later - your emotions on this issue are getting the better of you. – doppelgreener Nov 23 '13 at 7:18

Your question was flagged as offensive. You sounded incredibly pissed off (especially in the original title, before it was edited). That didn't really help matters — while your irate tone didn't contain anything offensive by the usual definition of the word, on the surface, from the mod queue it probably looked like you didn't have a serious question to ask and were just ranting.

Keep in mind that, like humans, lizards make mistakes too; this was probably a lapse in Bill's judgement. As a unicorn, infallible unlike humans and reptiles, I agree that your question didn't actually meet our definition of "offensive" and shouldn't have been deleted on those grounds. So I've undeleted it (and it looks like someone else has edited the cruft out for you as well).

  • 10
    Thanks for the enlightenment. I never realized that unicorns were infallible. It all makes sense now! – Josh Crozier Nov 23 '13 at 2:51
  • Cornets are cooler – American Luke Nov 23 '13 at 2:52
  • I didn't consider the tone irate at all. Bewildered was the intent and actual emotion, in fact. – Atario Nov 23 '13 at 3:11
  • 2
    Oh, and: shouldn't something, somewhere say what was wrong? Instead of just silent questionicide? – Atario Nov 23 '13 at 3:15
  • 4
    @Atario: Oh, definitely - this comes up all the time and we're hoping to find a way to address it. Here's one discussion - meta.stackexchange.com/questions/193789/… – BoltClock's a Unicorn Nov 23 '13 at 3:25
  • 4
    +1 for like humans, lizards make mistakes too. – devnull Nov 23 '13 at 3:44

Ah, you rubbed a mod the wrong way buddy(probably the title). One thing about SO is that we do pride ourselves on being the anti-Reddit, communication-wise. The line:

What the hell is going on here? I feel like I'm taking crazy pills!

Is certainly hilarious in its own right, ...buuut it doesn't quite fit in this culture. It's OK , part of the education. We do like well-placed dry-humor(nerdy LOL's = Kosher), we do.. so yeah. ANYWAY, congrats on the 2nd life there.

But I have to echo Jmort et al, substantively it's a good post. In general, err on the side of caution with humor. Especially in the title(you don't want to give a bad 1st impression)

There's an fAQ that outlines what questions to avoid - here's a list of 'em - https://stackoverflow.com/help/dont-ask

In the end, you do have the option to re-submit it. Try to make an SSCCE

  • 10
    You aren't a 10k user.. you didn't see the question, did you ? – Josh Crozier Nov 23 '13 at 2:18
  • 7
    If a mod insta-deletes a post, it's probably better to know why before reposting. – Mysticial Nov 23 '13 at 2:18
  • @JoshC - Nah I didn't see it. curious tho ;-) – Adel Nov 23 '13 at 2:18
  • @Mysticial - This insta-delete feature is intriguing .. so how does one get such supapowers!! Its a bit scary nonetheless – Adel Nov 23 '13 at 2:21
  • I'd repost the whole question here for you, but it feels like that would be rather frowned upon, considering. – Atario Nov 23 '13 at 2:21
  • 3
    @Adel Post was undeleted by BoltClock, there was nothing seemingly wrong with it.. as your answer implies. – Josh Crozier Nov 23 '13 at 2:36
  • 1
    @JoshC - touche, I'll eat the humble pie this time. – Adel Nov 23 '13 at 2:46
  • 3
    You could edit and add more information Abel, now that we sort of have a better idea of why it was deleted and why it was subsequently undeleted.... – jmort253 Nov 23 '13 at 2:47
  • 1
    I don't like the ...buuut it doesn't quite fit in this culture part. Shouldn't stack overflow be open to people from different cultures? If some posts are written in a different style than others, shouldn't that be considered inspirational as long as they're not offensive? – user68958 Nov 23 '13 at 13:09
  • @user68958 - yes, granted. – Adel Nov 23 '13 at 17:01

Question resurrected by the good Mr. "BoltClock's a Unicorn". Huzzah!

Consensus (but not including the insta-deleting party himself) seems to indicate that the problem was that people are truly, deeply offended by the word…uh…well, I guess I can't say it. Never mind!

  • If you peruse stackoverflow questions, you will be hard pressed to find any questions with hell in them. nothing persnal – Adel Nov 23 '13 at 3:13
  • stackoverflow.com/search?q=hell reports "12,863 results" as of this writing. 3,230 results for stackoverflow.com/search?q="the+hell" . – Atario Nov 23 '13 at 3:16
  • 11
    If folks had been deeply offended, the question would've been locked and you'd have had a 100 point penalty applied to your account. Instead, it was merely deleted. – Shog9 Nov 23 '13 at 3:20
  • @Atario - I had queried that too... and was debating my comment. But intuitively, it's rare. keep in mind - 6,140,689 total stack questions. – Adel Nov 23 '13 at 3:23
  • @JoshC: your comment has an unnecessary "or not" and "just", and either "unnecessary" or "noise". These are noise and not beneficial to the comment. Please revise or I shall grow rather cross with you indeed! – Atario Nov 23 '13 at 3:27
  • Sigh. My actual point there was that if we're going to go around rewarding and encouraging nitpicking, we're not going to have anything but an endless circlejerk of who can be the most nitpicky. That and a gradually dwindling supply of actual non-deleted content on which to nitpick. – Atario Nov 23 '13 at 3:34
  • 6
    I think it has been made clear enough that this was a mistaken deletion, and using the word "hell" is not usually grounds for such an action and nobody is "deeply offended" by it. But it made your question look like it was a rant, and somebody cast a flag - because with x million visitors every day, somebody is going to be offended by something. It was that unfortunate combination that brought about a lapse in judgement, that has now been corrected – Pekka supports GoFundMonica Nov 23 '13 at 3:37
  • @JoshC: Deleting your comment was exactly what I didn't want… -_- – Atario Nov 23 '13 at 3:38

Not the answer you're looking for? Browse other questions tagged .