Hot answers tagged

17

Network reputation You mentioned many times in chat being "at the bottom of the community". Understandably, this provoked questions from other people since your chat profile shows 183k network rep earned since 2011, despite your home site being The Great Outdoors, where you have only 101 rep: You further drew attention to this when you said: I have been ...


14

There are things that have happened behind the scenes that Evan is not being very, well, forthcoming about. I can't get into detail (though the edit war on the question is relatively public and should provide some clue), but I agree with JColebrand that removing Evan's participation from the question was not unwarranted. Two moderators (so far) agree that ...


14

Once I got into a car accident because someone merged into my lane without checking if I was there. When the cop arrived the person who merged into my lane tried to pin the crash on me because I was "passing on the right." Technically in the States you aren't supposed to overtake someone from the right lane, but I wasn't speeding and the other person crashed ...


13

StackExchange is a network of multiple Q & A sites. When you register for more than one site, you can do so using the same account (I see that you have done that). When any of your linked accounts reaches 200 reputation points, all of the linked (or "associated") accounts receive a bonus of 100 reputation points - going from 1 to 100 grants a handful of ...


13

Your options as the asker of the question are laid out in this Help Center article: What should I do when someone answers my question? Decide if the answer is helpful, and then... Vote on it (if you have earned the appropriate voting privilege). Vote up answers that are helpful and well-researched, and vote down answers that are not. Other users will also ...


13

I was one of those who voted to delete the question. I saw it first when it was already on hold, and if I had seen it before, I would probably be one of the close-voters too. Yes, you could very well say I did not like the question. But it is one thing to dislike something because it is pointless and quite another if it is potentially harmful. Why would I ...


12

How can comments disappear? From the main Stack Exchange FAQ section How do comments work?: Comments are temporary "Post-It" notes left on a question or answer. You should not expect them to be around forever: Once a clarification has been made, an edit added to the post to include new information, or the issue in the comment is otherwise resolved, it is ...


11

I think it would be acceptable to add a footnote to an existing answer to note the availability of updated syntax, but please be sensitive about it, and preserve the content that is applicable to users of older versions. If it cannot be done minimally, consider adding a separate answer instead. Also be prepared to accept (with good grace) a rollback by the ...


11

I am just going to analyse your question as the sentences flow across the screen. QUESTION: I am complaining https://dba.stackexchange.com/users/1192/paul-white-9. That is rather strange as Paul is one of the few I would call the central foundation of our community. Paul is never really biased and will allow communication in The Heap™ to flow rather than ...


10

No they are not synonymous. An UPSERT can be implemented without using the MERGE keyword and conversely UPSERT is just one possible use case for MERGE (when it has both a WHEN MATCHED THEN UPDATE and WHEN NOT MATCHED [ BY TARGET ] THEN INSERT ...) At least in SQL Server it is not required that MERGE have both (or indeed either) of these clauses. The ...


10

This has been implemented by the community team.


10

...for this I need to ask 100 relevant and useful questions... Yesterday I asked 2 questions, both have been upvoted, and I have not seen my socratic count go from 41 to 42. As the image above shows, it is the number of separate days, not the number of questions that is important for this badge. the duplicate was not 100% duplicated A question does ...


10

From Why can people edit my posts? How does editing work? in the help: If a user without edit privileges proposes an edit that does not comply with the guidelines above, it is ordinarily rejected in the review process. Even if a bad edit is applied to a post, other users will generally fix it. Users with sufficient reputation may elect to roll back the ...


10

Paul originally asked that question from a brand new, anonymous account (to encourage answers and gauge the reaction to the question on its own merits): https://dba.stackexchange.com/users/182461/user182461 After the post was answered, ownership of that post was transferred to his account in order to be able to accept his self-answer without breaking the ...


9

Welcome to DBA.SE. If you take some time to look around a bit on the main DBA.SE site and on the META DBA.SE site, you will find the help center which provides you with a wealth of information. In the article Why is voting important? there is a section that states: Voting up a question or answer signals to the rest of the community that a post is ...


8

After being closed as a duplicate, the duplicate was also closed, and subsequently deleted. I thought that there were checks in place that didn't allow that sequence of events to happen, as leaving orphaned duplicates isn't very useful, but I'll have to check up on that. It obviously can happen, and that's the explanation why you're seeing a page not found ...


8

The relevant part of the FAQ is here. What topics can I ask about here? It doesn't specifically indicate the "on topicness" of the subject area that you mention but questions about database internals are often welcomed and receive good answers. In my opinion a question asking about ACID compliance and issues surrounding write caching would be on topic for ...


8

Badges are not awarded immediately - many of them are only calculated once daily, so you'll need to give it more than 11 minutes to kick in. Update: Critic has now been awarded.


8

Yes. In fact, we would encourage you to edit your title to more accurately reflect the real question and the answer you received. Just be sure that the title, question, and answer make sense together. By the way, the question cannot be deleted (by you) because it has an accepted answer (see the link for a full description of when you can, and cannot, delete ...


8

SQL Sentry Plan Explorer (PE) can anonymize queries: There are limits though, and you will need to be careful to ensure that the anonymized code is still useful in the context of your question. I don't think PE will fully anonymize complex scripts with extensive DDL, for example. Other people might be able to make suggestions for that. Please make sure you ...


8

One of the considerations (that I am willing to go into here) was that retaining your answer might lead to a continuation of the unhelpful interactions between you and the question author. Regarding the "edit war" on the question, let me repeat the advice I left on another meta question: An edit is still fundamentally a suggestion for improvement, ...


8

My suggestion: do not target specific people simply because you think they can answer your question (people do that to me and, while I'm happy to help wherever I can, I also appreciate the ability to pick and choose which questions I focus on). There are other ways to get attention for your questions, and really you should stop thinking of any single ...


7

Yes, database theory questions should be asked here. You could equally likely post them to CSTheory if the FAQ matches. However, as with all questions, it has to meet the requirements for objective questions. Cheers.


7

Up in the top right, under the help v drop-down, there are two important links: The first goes to the tour, and the second goes to the help center. Both contain a lot of valuable information about the current site, in different formats (one as a walk-through, and one as a series of FAQs). If you've been through there and have a specific question you don't ...


7

Should the flag not have been helpful as it pointed out the need for the post to be edited to answer the question? I'm generally pretty generous when deciding whether to mark flags as helpful or not, but in this case I felt that the better decision (on balance) was to decline. This sends a message that the flag used was incorrect, whereas marking helpful ...


7

The Help Center has excellent resources for how the Stack Exchange model works. Looking at your question - what do I know? Something is wrong and a table is in a bad state. You cannot repair it as the storage engine doesn't support it You're using innodb As a non-MySQL person, that question seems bereft of details. What command have you issued? Is the ...


7

I've only just seen the question and my immediate problem with it is that it is asking about two very distinct problems: How to repair a table, and How to optimise a database. The two issues may be related in your mind but they are still very different and should be asked about separately. The second one, too, is extremely unspecific.


7

We gladly accept questions that are in English, even if the code isn't. The keywords for the language in question will almost always be in English, and if it isn't, we can probably find someone to help. Most variable and column/table names are symbolic logic when you strip things away (that's why examples always use A, B, C etc) so we have gotten pretty ...


7

Your question is answered in the Stack Exchange FAQ: How does deleting work? What can cause a post to be deleted, and what does that actually mean? What are the criteria for deletion? You can typically delete your own posts at will; for exceptions, see When can’t I delete my own post? below. To delete a post, just use the delete link below it. ...


7

sql-standard seems to be more general. I suggest we make both ansi-sql-standard and iso-sql-standard synonyms to sql-standard. ANSI and ISO have both been associated with the standard and I've seen used both the terms "ANSI SQL" and "ISO SQL" (and "ANSI/ISO SQL"), and still being used. status-completed


Only top voted, non community-wiki answers of a minimum length are eligible