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


30



30

Jack, first forgive my English, is not as fluent as I would like. I don't know you personally, I've been in this community for 2 years and 11 months, and we have regularly met in the chat room. Honestly, I think you are one of the most fair and impartial moderators here, and this is very important. Always willing to help users, regardless of the level of ...


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


28

Is there a rule where the spelling of answers has to be in "American"? No. See What should the standard spelling be - British or US? From that meta Stack Exchange Q & A's accepted answer by a Community Manager: Does SOFU have an accepted standard on language and spelling? Which is it? For bodies, no. For tags, US-English. ...


26

I'm going to give you some public tough love, but only since you asked. Your answers aren't actually all that good. Take this one: Will DB session terminate when client close DB connection The answers you posted don't actually answer his questions. They're good information, yes, but they're not answering the questions. If you want to earn points, ...


25

It's a sad day for Database Administrators.


24

No - it is just fine as it is.


24

Yes dba should be burninated because it... Isn't useful to connect experts in a topic area to questions they can answer Doesn't help describe the content of the question Doesn't add any meaningful information to the post Is ambiguous in that it could refer to the person or the role of a DBA Is simply the (abbreviated) name of the site


24



23

As a lower-volume site compared to, say, Stack Overflow, we're able to manage behavior much more reliably, and we just don't get a lot of the nonsense that is inevitable with higher volume. We're also constrained to people who work with databases, rather than all people who touch computers, and that tends to weed out at least a little bit of the vitriol. I ...


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


23

Based on Crow's Foot notation: Symbol reference: image source Intended meanings as drawn (artistic licence employed): One (and only one) Database Administrators site Many questions Zero or many site achievements Zero or one featured meta questions (typically; of course right now we have two) The far terminator is currently a circle. I guess this could ...


23

Jack, as the person that thanked me for my first few answers & encouraged me to join The Heap, I'd like to thank you for the time you have invested in DBA.se & also for the work you have put into dbfiddle.uk. You will be missed. Please don't be a stranger :-)


22

Thanks for bringing this up on meta so constructively. The consensus here is that we use the term 'SQL Server' and not MSSQL - it might not always merit an edit just to make that change but it's always preferred. Although the abbreviation MSSQL is often used, it tends to be by those who know the product less well - I just did a quick survey of blogs by ...


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


22



22



21

It is jarring, but taking the background colour away entirely leaves it hard to tell what is code and what isn't: I think we should consider a third option, ether a lighter grey: Or something else: Just for reference, this is what we currently have:


21

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


21

Before going into the question, I'll address two of your comments under the question and answers because I feel they show your thinking: @user you say that you hold yourselves to a higher standard here, and yet, the first question I attempted to answer (because it had a bounty), had a completely wrong top answer. The top rated answer, with 5 up-votes, ...


20

We do have issues with folk sometimes doing pointless edits or putting in minimal effort because they are after a badge or something, so we sometimes get a bit trigger-happy. In this case, I think you've taken the flak for others and your own edits are mainly fine so I've lifted the review ban. Thanks for not getting huffy about this and bringing it to meta ...


20



20



20

Personal opinion: I found it funny. (Note: I'm old enough to be that DBA. I have several books with weird covers. I also read them. I'm sure a lot of what I say sounds weird to younger people ;)


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


19



19

Yes database-administration should be burninated because it... Isn't useful to connect experts in a topic area to questions they can answer Doesn't help describe the content of the question Doesn't add any meaningful information to the post Is ambiguous in that it could refer to the person or the role of a DBA Is simply the name of the site


19



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


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