Hot answers tagged

71

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: Formatted text of the query/procedure/function. Indenting SQL by 4+ spaces on each line is usually best. Schema (CREATE TABLE); use text, not images Table, index, and constraint definitions (scripts). Even better: A link to a demo that reproduces the core of the problem. The performance or query-optimization tag. ...


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


1

Taken from a comment by Wilson Hauck on a MySQL performance issue question. Instructions for MySQL Performance Questions Computer specifications RAM size SSD/NVME versus HDD on MySQL Host server Please post on pastebin.com and share the links. (Or similar product.) Additionally from your SSH login root, text results of: SHOW GLOBAL STATUS; (after ...


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