Hot answers tagged

59

Howdy© and Welcome aboard®! We're glad you chose dba.stackexchange.com for assistance with your homework a production emergency writing your non-trivial query. When you need help writing a Query From Scratch©, the first thing to do is make sure the query you're writing doesn't already have a lot of common answers. Some of the most popular query writing ...


32

SQL Server What's the difference between a temp table and table variable in SQL Server? What's the difference between a CTE and a Temp Table? Why use both TRUNCATE and DROP? Does restarting SQL Server speed it up? Q: Should I use NOLOCK? Is NOLOCK always bad? Justify NOT using (nolock) hint in every query Why Does the Transaction Log Keep Growing ...


31

If you have tab-delimited text you can use this web site tool to convert it into a table, either in 'MySQL' or 'Unicode Art' style, eg: +-------+-------+ | LEVEL | DUMMY | +-------+-------+ | 1 | X | | 2 | X | | 3 | X | +-------+-------+ ╔═══════╦═══════╗ ║ LEVEL ║ DUMMY ║ ╠═══════╬═══════╣ ║ 1 ║ X ║ ║ 2 ║ X ║ ║ ...


22

These types of questions are harmful to the site and should be quickly closed and probably deleted. I know that SO has a no-shopping-list questions policy, and this feels like a shopping-list. It's not just SO, this has been established network wide for a long time. Just two meta.SE examples: List questions: Community Wiki? What is the definition of a ...


20

The obvious solution is to let answers that are "plain wrong" be downvoted into oblivion - where they will serve a useful purpose advertising their wrongness :) The problem is that there are two kinds of votes: informed votes from people who could have answered the question themselves or who have taken the time to double check the answer all other votes (...


18

I'm going to quote this Q from the "Stack Exchange Grand Central Meta" (asked by our own star GBN) How to deal with upvoted yet clearly wrong answers As others said before me, you should use the options SO already provides to you: Leave a comment Downvote the wrong answer Provide or upvote a correct answer If it is really, really wrong (...


10

I don't think "this vs that" is a good fit for anything that attempts to be canonical. Each DBMS will change over time, and as such, the answers will vary substantially over time. These types of questions are just troll fodder, in my opinion.


10

Agree with the top two answers. Just writing separately to add that wrong answers can be useful: Seeing wrong answers is a great way to learn something! This is especially true if the comments explain why the answer is wrong. It often happens that the experts are mistaken. Keeping the answer visible means that experts can come back and double check, and ...


8

Acceptable in moderation If the question is specific and answerable (i.e. passes the 'not a real question' test) and is on-topic per the FAQ then it would be on topic. One could probably envisage questions within these criteria that could be viewed as trivia in a subjective judgement. However, the FAQ does not explicitly include 'database trivia' as ...


7

How to create a Minimal, Complete, and Verifiable Example for database-related questions Database-related questions asking for practical advice will get the most helpful answers if they provide a framework others can use to reproduce that problem. With that in mind, when asking a question please create a framework that is: Minimal – Use as little code as ...


7

Off-Topic Let's make it a simple rule that 'trivia' is always off-topic on dba.se - even if this sort of question is borderline for SO and/or other sites on the network, we have an 'expert' focus and culture, and trivia is not going to attract the kind of contributors we need more of, and of course is unlikely to help anyone with their 'real-world' database ...


5

JUDGMENT CALL Isn't this kind of like homework? It can be very tough to draw the line and determine that a question was intended to be trivia even if it sounds like trivia. I don't think there is a way to make a blanket policy that all questions that seem like trivia to one person should be closed. Let the community decide, or have a bar (ridiculous trivia ...


5

Unacceptable I think that questions that involve specific knowledge of a corporate or body politic (hereafter referred to as company)'s internal members ... should not be asked here. If you want to know the internal decisions made by a company, such as "why did the company choose this license type", that question can only be answered by the company, and we ...


3

I can see the points made by the other answerers here that incorrect, invalid, and misleading answers can be useful - certainly if I wanted to know the wrong way to do something. I tend to imagine people are searching the web for an answer not to confirm they are right when in fact they are wrong, but to find the actual answer. Imagine your surprise if ...


2

PostgreSQL PostgreSQL's official client, psql, makes this task super easy. It's a command line client. Further formatting options are available, Formatting \a toggle between unaligned and aligned output mode \C [STRING] set table title, or unset if none \f [STRING] show or set field separator for unaligned ...


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