27

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


22

Ask a new (follow-up) question, including a link to the previous one if it provides useful context. The new question should still make sense on its own, of course. As a general rule, it is better to start a new question when a question edit would invalidate good answers. We don't charge by the question (but please don't go nuts - a hundred similar, very ...


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

I agree with Leigh's suggestions (see comments on the question): Remove wording from the site indicating that basic SQL is not allowed. I'm not sure if I would promote it, simply not ban it. Stop migrating basic SQL questions to Stack Overflow.


19

No, because... We have a niche, an 'expert' focus and we don't want to dilute it too much. Being flexible with the definition of 'advanced' SQL which we allow according to the help page is fine, but opening the floodgates to every 'how do I join two tables' question will eventually lead to the overall quality and perception of the site degrading. Or, as ...


19

Yes, SQL Challenges should be considered on topic because... they provide the community with new approaches to existing problems. they show the more exotic forms of SQL, and are an invaluable way to hone your craft. they are popular and may attract new expert users to the site We love fun


16

People have asked data modelling questions on dba.se before, so it's not off-topic for the site. If you have a question that's specific enough to fit the question/answer format then it's going to be considered on-topic. Note: 'please design my database for me' is not. You will need to get to a problem that's specific enough that somebody can answer the ...


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


15

database-recommendation questions are not off-topic, but experience has shown that they need to be better than average to avoid being ignored or closed, especially in recent times. Click on that tag to see existing questions. Be specific about the circumstances, requirements, and constraints you face up front. For example, you should say whether the ...


14

My personal guideline would be that homework questions are fine, as long as they put some effort into it. Dato's question is a good one to me, because the asker has put in some effort to solve it. On the other hand, jordan's question runs a bit close to my "no effort and just wants answers" spidey-sense. There was another question a couple of days ago (that ...


13

Simon Righarts has highlighted two good examples and I'm broadly in agreement with his classification of them. I'd like to add a requirement/expectation for homework and "please do my job for me" questions, the addition of DDL and sample data scripts. These questions usually involve relatively simple query syntax issues, which are more valuable to future ...


12

We have made a decision to include B.I. questions on topics such as reporting into scope for DBA.SE. Questions about SSRS are certainly welcome here. I'm pretty sure I've already seen discussion about the SSRS metadata on DBA.SE before, although I can't find it with a quick search. In short, the answer to your question is that SSRS questions are certainly ...


12

Black box test: Are the shopping questions causing a problem? Shopping questions on enterprise or development tools can be quite deep and may require some insignt into the OP's problem to sensibly answer. For example, getting reliable independent information about B.I. tools such as Cognos or MicroStrategy is not easy to do off the internet. In some cases ...


12

I don't see any problem with posting it as a question at the site. We love complex issues! Depending on how sure you are about your analysis results: if you are not very sure about your findings: one question with two parts (within the question): the problem and your analysis/results. Others can answer if there are any flaws with your analysis and ...


12

It would be very rare for this sort of question to be accepted by the community here. The potential problems are many, but include: Answers tend to go out of date more quickly than for other types of question Answers are often based on personal preferences The questions are too often lacking enough detail, resulting in extended discussion These types of ...


12

I edited and upvoted your question because I found it on-topic and interesting. That said, other members of the community had already voted to close it, and left it closed after an automatic reopen review triggered by one of your edits. Also, experience has shown that database recommendation questions have to be pretty exceptional to remain open here. On ...


11

Personally, I don't think this type of question is a good fit for our site for several reasons. Bigger/more hardware will almost always lead to better performance. As such the answer "As much as your budget will allow" is always a valid answer. Too many implicit assumptions. You can't possibly fully describe all the details of your system to us so we are ...


10

The "on hold" notice placed on your question included a link to the Help Centre, which I repeated in a comment on your question here. To quote: Questions that need additional work or that are not a good fit for this site may be put on hold by experienced community members. While questions are on hold, they cannot be answered, but can be edited to make ...


10

This stack part is quite young (at least it seems that way to me) and I'm not sure if such question would be tolerable. No, this particular Stack Exchange site (that's what they're called) is quite mature, and we're well prepared to help people, so long as it fits in with our scope, and as to: I want to ask specific question - what database should I ...


10

This has been somewhat discussed before: Are DBA certification questions appropriate? Can I ask conversational questions? (Training) I think the vast majority of questions about certification will be off-topic for one of the usual reasons, but that's not quite the same as saying that any question that mentions certification will be automatically off-...


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

No, why a query is "too slow", compared to a different rewriting of the query, does not sound like a "too basic" question. There may be various reasons for the performance difference, from the two being inequivalent (so the efficiency comparison is likely pointless) to being able to utilise different indexes or due to optimizer's restrictions or missing ...


9

'How do I improve this schema?' is likely to be too broad and subjective to make a really good question. If you have specific issues then you can certainly ask questions about those. In general, 'I don't know where to start' is not acceptable on SE sites, as you are expected to have at least done some research on your own. In fact, this issue was so ...


9

I agree with @ConcernedOfTunbridgeWells, data modeling (or data architecture) questions are definitely on-topic and appropriate in DBA.SE, and they are usually encompassed within the database-design tag. On the other hand, (a) due to the fact that you categorized the present question with the discussion tag, (b) making the assumption that you have the ...


9

Neither. SQL Challanges (as described in the question) are neither automatically on-topic, nor off-topic. Each question should be evaluated on its merits by the community. I would expect questions of this type to be well-received, if they: Fit in Q & A format Are clearly presented and explained Contain sufficient information to identify correct ...


8

"Here's my problem. Here's what I've tried. Here's why it's still a problem." This pattern will get you a lot more useful responses than "can you suggest a better design?"


8

I think this is a good question for DBA. Mostly the "too basic" label would apply to simple operators. The most common example I can think of is a few times a week someone asks a variation on conditional counts that are trivially solved with a SUM(CASE WHEN.... Your question is fairly complicated and specific - it's not likely someone who knows a little ...


8

Because they will encourage speculation, and not hard-and-fast answers, I say yes, those are off-topic. The motivation for StackExchange sites is the answering of objective questions, in a timely manner. Since we can not be objective and timely at the same time when answering these, we should close them. Duplicates should be doubly so closed, as the system ...


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


8

Questions about how to circumvent licensing restrictions are off-topic, for obvious legal reasons. However, you're welcome to ask for database recommendations,just make sure your question is clearly defined.


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