Questions tagged [discussion]

The question you're asking is designed to solicit opinions or best-practices on a particular topic, with the goal of reaching community consensus.

Filter by
Sorted by
Tagged with
93
votes
12answers
2k views

It has been a great privilege to serve this amazing community as moderator. Thank you

Today I'm handing back the diamond you gave me in 2011. Some of you will not understand or agree with my reasons for doing so, but the nature of the community we have on this exceptional site leaves ...
75
votes
49answers
3k views

A new fiddle for dba.se

SQLFiddle has been an essential tool and a great complement to dba.se for a very long time, but it has gone downhill a bit in the last year or two. I have also wondered for some time what a 'fiddle' ...
47
votes
1answer
1k views

Help me write this query in SQL

I'm trying to get help writing a query from scratch using Structured Query Language, or SQL. What information do you need from me to get my boss to stop screaming? I've asked all my co-workers for ...
41
votes
7answers
974 views

Let's burninate the SQL tag!

The sql tag was discussed most recently in Is the [sql] tag useful for DBA.SE? (May 2015). Things have changed, and it is time to revisit this discussion. The most popular views last time were that ...
40
votes
4answers
917 views

Should basic SQL questions be allowed?

I’m going to buck the pervasive mentality here and ask the question:    Why shouldn’t dba.stackexchange.com include basic SQL questions? Previous related discussions: How do we ...
38
votes
1answer
1k views

Canonical Answers

After discovering the pot of gold that is ServerFault's What are the canonical answers we've discovered over the years?, I'm inclined to think dba.se could do with the same. If agreeable to ...
34
votes
18answers
1k views

We need to formalize a site title/name. Does “Database Administrators” still ring true? [closed]

We had some original thoughts here: Why Database Administrators? but that seems to read more of a "why is this site named this way" and not so much of a "we need this name". So I'm making this thread ...
33
votes
3answers
385 views

Whether we should be CAP COPs

A certain user has suggested a boatload of edits recently. The changes have been either largely or completely revolving around the upper-casing of Transact-SQL keywords. For example, a post that ...
30
votes
4answers
340 views

Can We / Should We Strongly Encourage Users to Specify RDBMS on the “Ask” page?

More than most other sites, the majority of our questions require a specific piece of information: What RDBMS and what version is the asker using? If it's possible, would it be a benefit to add this ...
29
votes
4answers
817 views

Are licensing questions within our scope?

I noticed Server Fault preemptively posted a dummy question explaining that they don't give licensing advice, as you really need to figure out licensing with the company granting the license. They use ...
29
votes
4answers
817 views

“Database Administrators” needs to die [duplicate]

Every few weeks another sharp poster asks: Why are you asking DBAs about source control? Why are you asking DBAs about performance? Why are you asking DBAs about database design or data warehousing? ...
29
votes
0answers
563 views

Database Administrators Top User Swag

As a thank you for being awesome, if you are on page 1 or page 2 of … https://dba.stackexchange.com/users?tab=reputation&filter=all … we'll be sending you a little care package ...
28
votes
8answers
458 views

Why Database Administrators?

When I comited to this site, the title was Database. It suddenly became Database Administrators, why that ? Talking about database is not only the administration side it's all the task around also. ...
28
votes
1answer
223 views

2015 Moderator Election Results

Database Administrators' fourth moderator election has come to a close, the votes have been tallied, and the new moderator is: He'll be joining the existing crew shortly — please thank him for ...
27
votes
10answers
2k views

What other databases would you like to see on SQL Fiddle?

Updated We have the opportunity to expand upon the database options found in SQL Fiddle. Which database (including version) would be the most useful for the community? Some thoughts I've had: DB/...
27
votes
4answers
577 views

How do I provide an execution plan to someone for analysis?

I have been asked in another dba.stackexchange.com question to provide an actual execution plan. What is the best way to acquire this in order provide all the information required for analysis? ...
27
votes
2answers
490 views

How do I include tables with Ascii art lines in my answer?

Some answers on the site like this one and this one include tables drawn with ascii art. Is this done by hand or is there a tool I can use to help me?
25
votes
2answers
217 views

Do we accept database comparison questions or are they offtopic?

This is not the same as: Should we allow, even encourage, "feature comparison style" questions? Do we want to support questions such as: MySQL vs MariaDB Postgres vs MySQL Oracle vs MSSQL ...
24
votes
25answers
825 views

What kind of questions are allowed on Database Administrators ?

When I first committed to DBA, it was generically named as "Databases". Now that we have the private beta up and running - what questions are allowed in here ? The site name indicates that the ...
23
votes
3answers
219 views

Burninate the [dba] and [database-administration] tags?

The database-administration and dba tags are used on 1039 and 148 questions respectively. They seem useless to me (on a site called Database Administrators) but I am curious as to how others feel. ...
23
votes
1answer
245 views

Why is dba.stackexchange so…welcoming?

Perhaps this is but my first impression of DBA, but it's surely a pleasant one. I recently asked a fairly basic question about Postgres's indexing abilities. I was greeted with AMAZINGLY cordial and ...
23
votes
1answer
127 views

Move tags to below title instead of at end of question

Ever had this feeling that you're missing some information when you're reading through a question? Well I do too. You start reading this really long question only to find out that some specific ...
22
votes
4answers
273 views

Is the [sql] tag useful for DBA.SE?

Both DBA.SE and Stack Overflow suffer from a similar problem, when users post sql related questions there is a tendency to solely tag the question with sql but exclude the RDBMS. This is great if ...
22
votes
0answers
214 views

2013 Moderator Election Results

Database Administrators' third moderator election has come to a close, the votes have been tallied, and the new moderator is: He'll be joining the existing crew shortly — please thank him for ...
21
votes
3answers
397 views

Should we change the formatting of backtick markdown elements?

At the moment, backtick markdown elements are rendered with a grey background. This can get a little jarring when used frequently, for example: I have a table Widgets with columns, WidgetID, Name, ...
21
votes
2answers
367 views

My reviewing of questions is declared “blatantly bad”; why, and how can I improve?

I've started seeing this strongly worded message recently when clicking the Review link: You have approved numerous edits or first posts that were blatantly bad and needed editing or should not ...
21
votes
2answers
211 views

Where to draw the DBA/DB developer line?

I'm a developer with DBA experience. Sometimes I have questions about indexing, sometimes SQL and sometimes how a C# applications interacts with the database. Where is the line drawn between what ...
20
votes
22answers
760 views

DBA.SE Xmas caption competition - 'tis the season to be jolly

DBA.SE Christmas caption competition In the spirit of the festive season, hats and all such matters, we proudly present the DBA.SE caption competition. The rules are simple: Answer this meta ...
20
votes
3answers
644 views

Why are users correcting my British English answers to the American spelling?

Why are users accepting revisions to old answers, where the revision is simply converting my British spelling to the American spelling? Is there a rule where the spelling of answers has to be in "...
19
votes
2answers
191 views

Are two answers by a single person on one question A Good Thing™?

I know there is an "official" StackExchange meta-post already concerning this question, however I think it would be suitable to have our own post that reflects our position. This really excellent ...
19
votes
4answers
519 views

Opinions about merging the Business Intelligence proposal into this site

Now officially included The scope of DBA.SE has been adjusted to include Business Intelligence and the B.I. proposal has now been closed. Thanks to all concerned. Edit from JColeBrand - current ...
19
votes
0answers
132 views

Remove tag [tag:access] and blacklist it

The tag access has no description and I've seen it used in at least three different contexts: Microsoft Access, but there's already a tag ms-access for this. privileges a user has on an object, but ...
18
votes
4answers
456 views

Design for Database Administrators

I'm Jin, and I'll be working on the designs for the Stack Exchange sites as they graduate from the beta phase. Each site will have its own unique theme that will reflect its topic. However, all sites ...
18
votes
1answer
549 views

Minimal, Complete, and Verifiable Example

How can I best ask my question so people will be able to understand it and reproduce the problem if necessary?
17
votes
6answers
374 views

Is MS Access on-topic?

I thought about asking a question regarding triggers in MS Access but wasn't sure if that belonged here or not.
17
votes
3answers
352 views

I don't think the votes on my answer are merited

I assisted somebody with a problem in a chat session that went a lot further than just the question and I don't think my answer to the original question is all that great. The OP went on and asked ...
17
votes
2answers
228 views

If an answer has more upvotes than my chosen answer should I change my chosen answer for the sake of readers in the future?

I have a question HERE which has more up-votes for an answer I have not chosen than the answer I have. What I want to know is if an answer has more up-votes than my chosen answer should I change my ...
17
votes
2answers
480 views

Do We Want Hats™?

In 2011, the Gaming Stack Exchange hosted an event called Hat Dash, where users earned "hats" for their gravatars by completing certain tasks (analogous to badges): Certain actions would trigger the ...
17
votes
3answers
477 views

Blogoverflow blog anyone? If you want to help with the DBA.SE blog, here's the signup list?

Blog Overflow blog anyone? If you want to help with the DBA.SE blog, here's the signup list! What is Blog Overflow? Why, to put it very simply, it's the StackExchange Community Blogging Site. In ...
17
votes
2answers
169 views

Which site is best for code reviews of queries?

Imagine a junior database developer / DBA that may not have an avenue to get their SQL code reviewed for best practices and such as they are learning the ropes. There is of course the Code Review ...
17
votes
2answers
148 views

What about business intelligence?

I was wondering if business intelligence has a place on this website. In business intelligence, we can see three or four domains that relate to database expertise: ETL Data warehousing Data modeling ...
16
votes
4answers
196 views

Should we tag with all terms in a tree?

I've noticed a couple of questions that have all of the tags: oracle oracle-11g oracle-11g-r2 Ideally, the tagging would support hierarchies, and know that 'oracle' is a broader term of 'oracle-11g-...
16
votes
3answers
518 views

Shall we add a new 'off-topic' reason for questions that really need professional support?

We get questions like this where it is immediately obvious that the OP has a much bigger issue than they realise, and they need a consultant or vendor support, much hand holding and hands-on access to ...
16
votes
1answer
162 views

Database Administrators Moderator Business Cards

We recently printed some business cards for our Stack Exchange employees and they turned out great. It got us thinking: our sites' moderators have been working hard to keep our sites high quality for ...
15
votes
4answers
374 views

2015 Moderator Election Q&A - Questionnaire

In connection with the moderator elections, we are holding a Q&A thread for the candidates. Questions collected from an earlier thread have been compiled into this one, which shall now serve as ...
15
votes
2answers
345 views

Is DBA a place for homework questions?

Is asking homework questions allowed or should it be allowed/tolerated in dba.stackexchange.com? Is there a guideline for this in stackexchange?
15
votes
2answers
279 views

Commenting on questions you don't intend to answer

I will often take a look at a question, realize that it's not one I'm likely to be able to answer - but still have something useful to offer in comments: a guess at a possible answer (especially ones ...
15
votes
3answers
154 views

Should old questions that have no answers and are “too localized” or “too broad” be closed?

For reference, look at this question: https://dba.stackexchange.com/questions/39302/invalid-object-sql-server-2005-express The question appears to be abandoned, and offers no real help to future ...
15
votes
1answer
305 views

Asking query performance questions

What information should be provided when asking how to improve the performance of a query?
15
votes
1answer
178 views

What should our list of off-topic close reasons be?

Close reasons are changing, as well as the sub-reasons for off-topic. We should probably try to avoid falling behind. This post borrows quite heavily from this post on meta.robotics (which borrowed ...