Hot answers tagged

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


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

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

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


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

Bumps without bounties are appropriate if the question is modified in a way that makes it more clear or brings new information to light. Normally when you ask a question you are also doing research on it yourself and perhaps even trying some things that provide partial answers to the problem. Posting this information not only provides a bump for the ...


11

This has been implemented by the community team.


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


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

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

I would suggest using the backtick character like so `@param1` `@param2` `@param3` provides this:


9

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


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

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


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

I'm assuming you are referring to this question? If so, there is noting wrong with the question and no great reason why it hasn't got an answer - I've performed a minor edit to remove the unnecessary 'thanks' which will bump it (I wouldn't normally edit a post just to do that) - but as you say the way to draw attention is to offer a bounty.


7

I think the key to stopping it is just to keep rejecting the edits. Once folks find out that it doesn't get very far, they will stop.


7

We've recently deployed a system that is much more comprehensive than a simple IP block. It's fed from actions that users and moderators take, and the data is shared across the network. This means, folks rejecting spam edits on Stack Overflow are also helping to keep DBA, Skeptics and Seasoned Advice a cleaner place. In the case of edits, if a user spams ...


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.


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