Hot answers tagged

70

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


28

Personally, I think this is dangerous to allow. Licensing is a vast landscape and there are mines everywhere. Being out of compliance is something that can get you and your company into serious hot water. Pulling up some Stack Exchange answer in the middle of an audit with Microsoft Legal is not going to get you off the hook. Ask yourself this: Do you want ...


23

As many of the following as possible: Database product, precise version, and edition. Formatted text of the query/procedure/function. Current and desired performance levels. Things you can and cannot change (e.g. can add indexes, cannot change the query). Query plans Ideally the post-execution variety, containing runtime information. Estimated execution ...


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

No Questions that are trivial enough to be answered in this way are too simple for dba.se and should be closed. If it does warrant a full answer, posting the answer as a comment makes the solution less discoverable for future visitors. Comment-answers make life harder for people trying to use comments for their intended purposes. Answering a "poor"...


15

Some of the license questions and answers we have on the site are useful and I think DBA.SE is making the internet a better place by hosting them - I wouldn't like them to be banned altogether here like on SF because we don't have the same reason: they have unlimited scope as they cover thousands of software packages and license agreements. I do think we ...


14

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


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.


9

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


6

Yes This is the official dba.se guidance for canonical links - although it is not guaranteed to be up-to-date (and currently it is slightly out-of-date). See the comments below this post for a list of magic tags and their renderings. Hover your mouse over the rendered magic link to see a tooltip of the target URL. The follow examples are excluded ...


6

I agree with what Paul White said and I understand where you are coming from as well. In the short time that I've been here I've also noticed some of my comments being deleted. After I first noticed a comment was deleted I thought "WTF?" As I thought about it over the next couple of hours the more realized this is good housekeeping. Looking back at those ...


5

Already some good answers have been given but since in last part you talked about help so here is a bit but then again we can give some help as well. A little help which I know from MSDN forum which Microsoft Contingent staff provide to such question is You can also call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to ...


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


3

Instructions for PostgreSQL Performance Questions Copied from the postgresql-performance tag info. About improving / explaining the performance of existing queries. May concern particular query techniques or the setup of your hard- and software. Tag with postgresql as well. Questions about trivial queries should rather go to stackoverflow.com. See DBA Help ...


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