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
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' ...
-3
votes
1answer
68 views

Should Stack Overflow provide hints on asking at DBA?

I just posted a question on meta.stackoverflow.com suggesting that it should provide a hint to questioners that they should ask in dba.SE instead, perhaps trying to use AI technology to detect the ...
9
votes
3answers
141 views

Why is there no option to flag Answers posted as Comments?

Often I see Answers posted as Comments - sometimes I will add a comment asking the user to add an answer themselves, but this is usually ignored. Posting Answers as Comments clearly impacts the site ...
10
votes
2answers
122 views

Do I misunderstand the “too localized” close reason?

During review, I see that a lot of people vote to close questions as “too localized” when I would think they are actually too broad. One example is here. There is no typo, basic error, ...
12
votes
8answers
617 views

Community Promotion Ads — 2019

2019 is here! And with the new year, as usual, comes a new iteration of Community Promotion Ads! Let’s refresh these for the coming year :) What are Community Promotion Ads? Community Promotion Ads ...
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 ...
4
votes
8answers
163 views

Synonyms and Redundant Tags

Post synonyms and redundant tags here (one tag set per answer) for us to ponder and potentially edit out of existence.
-5
votes
2answers
87 views

I think that we should encourage more questions!

I saw this question today and it was rightfully put on hold because it was cross-posted to stackoverflow (where it already had an answer anyway). However, one poster told the OP that "Besides, this ...
2
votes
4answers
366 views

Can/should this question be prevented from deletion?

The question Can I update my Microsoft Enterprise SQL Server? was migrated from stackoverflow.com and then rejected. If I understand the Auto delete rules correctly it will be deleted in about 30 ...
2
votes
1answer
25 views

Would a question about improving the performance of a third-party database be on-topic?

Microsoft's Windows Server Update Services product (WSUS) makes use of a database, which unfortunately performs very poorly. There is a third-party script available that modifies the database (I ...
13
votes
5answers
301 views

Should 'trivia' questions be off-topic

There is nothing in the FAQ or here on meta that specifically says these questions cannot be asked, and I think some other sites like SO tolerate them to a degree, but perhaps the expert focus here ...
3
votes
2answers
54 views

Is this PostGIS database design question better suited to the DBA site or the GIS site?

I asked the following question on the GIS site: https://gis.stackexchange.com/questions/328463/postgis-proper-way-to-model-object-that-follows-sections-of-another-objects-pa Is that the best place ...
5
votes
2answers
93 views

Criteria for adding another site to the Closed Vote Site Migration List

After doing some digging (i.e. FAQ for Stack Exchange¹, What is migration and how does it work?², and Can we have an Off-Topic > Belongs on StackOverflow option?³), I'm unable to find any explicitly ...
18
votes
1answer
551 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?
5
votes
2answers
54 views

Should syntax errors / script errors be corrected via edits?

Today I found an answer from a new poster that has a syntax error in it. As far as I can tell, I have a few routes to attempt to deal with this: Edit the post directly without commenting - this ...
13
votes
2answers
178 views

Disclosures, every post/comment or is profile enough?

Many of you may know that a good portion of those who ask and answer on this site work for companies that may have a hand in different solutions or consulting services that could otherwise sway ...
4
votes
1answer
43 views

flagging clarification for low level answers

on this answer which basically all it says: Edit the connection and be sure to select the version of mysql installed on your PC in the "Local Client" section I believe it is a low level answer, ...
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 ...
3
votes
0answers
45 views

Are DB modelling review questions on-topic? [duplicate]

For example: I have a problem P and to solve it I have designed this schema S. Do you see any problems with this design? If yes, what would you change to fix/improve it?
14
votes
2answers
215 views

Posts offering money for solution

I just saw this new post (Paid) How to optimize a MySQL joining to itself? that includes a link to the same question on freelancer.com I am not sure how I feel about it. I looked for related posts ...
0
votes
1answer
84 views

User was removed — lose 810 points

Wow! I answered or commented on someone who was so bad that he eventually got removed. He must have posted hundreds of Questions? Was I that much of a sucker to "help" him dozens of times? (It's ...
-7
votes
1answer
81 views

Why doesn't StackExchange discourage smartass responders?

Nearly every question I check on StackExchange, there is some smartass commenter. If someone asks something that is not clear, instead of saying something like, "It is not clear. Do you mean [this] or ...
3
votes
1answer
54 views

Why was this edit rolled back?

I edited this answer to fix a mistake in english grammar as well as a powershell syntax error. I believe my edit is correct but the answerer has rolled it back. As of now, the script in the answer is ...
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 ...
0
votes
1answer
32 views

how to show data as in a grid for adding in posts? [duplicate]

Often times I need to represent data in a way similar to this one: ...which is: +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | ...
6
votes
2answers
90 views

Boilerplate Comments for Closing Questions

I ask this purely because I'm lazy, but can we compile a list of boilerplate comments to leave on questions receiving close votes? I ran across this question where hot2use posted a terrific close ...
5
votes
1answer
237 views

How can this question still not be clear enough?

Recently I've tried to revive one of my old, interesting and - at least, for me - pretty clear question from closure. After editing the post and casting a reopen vote, unfortunately it seems I've hit ...
9
votes
1answer
81 views

Answer my own question from other's suggestion

A member posted comments on a question I recently asked on DBA StackExchange. One of his comments helped me find the right answer to my own question, so I posted the answer myself. But the user who ...
5
votes
1answer
104 views

Would asking why an incorrect query is so much slower be “too basic”?

In doing some fairly small-scale data massaging/cleaning, involving JOINing a couple of tables, an early, erroneous attempt at a solution was drastically slower than (what I believe is) the correct ...
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/...
2
votes
1answer
40 views

Old questions showing recent activity

Why do some questions come to the top of the active list when nothing seems to have been changed? Example question:Old question without noticeable activity
6
votes
3answers
95 views

Should there be a tag for timescale or timescaledb?

Actually there is a tag for time-series-database, but as the OP in this question has suggested, may be there should be a tag for timescale or timescaledb. A search for timescale returns 12 results, I'...
8
votes
1answer
109 views

Where should I post my question? DBA, Software Engineering or Code Review?

I want to ask about the structure of my database but I'm not sure where should I ask. Code review has the SQL tag about schemes and Software Engineering has the SQL about desing, but Database SE also ...
1
vote
2answers
36 views

What are the guidelines for flagging posts, again?

I came across this answer in the First Posts review queue. It didn't look like an answer to me, but rather a comment requesting clarification from the question author, so I flagged it as "Not an ...
2
votes
2answers
46 views

Product support for a master data management product

I manage support for a master data management product. We have customers who have asked for a more public community site to share questions and answers in preference to or in addition to the existing ...
11
votes
0answers
101 views

2018: a year in moderation

It's New Year's Day in Stack Exchange land... A distinguishing characteristic of these sites is how they are moderated: We designed the Stack Exchange network engine to be mostly self-regulating, ...
10
votes
2answers
125 views

Can we add text to the effect that ORA-00600 errors are off-topic?

(IMHO) Oracle ORA-00600 errors should be considered off-topic here because they're internal errors and there's very little we can do to diagnose and help people with them. The recommended and best way ...
13
votes
0answers
239 views

Deleting Unsuitable Content from the Database Administrators Stack

For the backstory, see Paul's post on the topic. If you notice unsuitable content on the site, you can assist in removal. Depending on your reputation, you can assist by taking the following actions:...
8
votes
1answer
99 views

Can we open “Launch Python Script from Insert Trigger”?

Launching a python script from an insert trigger As you can see, OP is asking for coding specifics as they do not know how to do this. I really don't see how "How can you make a python script execute ...
5
votes
1answer
100 views

Huge number of visits

In the first 24 hours after posting, Identity column re-seed: when it is necessary? garnered about 700 Visits. Was it real? Was it some form of hacking? (I'm not complaining; my Answer got a lot ...
6
votes
2answers
45 views

Should a newly-created tag be propagated to existing questions?

Apologies if this has been asked before. It seems like something that would have come up early on, but I do not see an existing meta question on the subject. If I create a new tag for a product ...
-3
votes
1answer
47 views

Burninate “schema”?

The schema is currently defined as, A schema of a database system is its structure described in a formal language supported by the database management system (DBMS) and refers to the organization ...
2
votes
1answer
21 views

Consolidating RDBMS-specific tags to one on functionality?

In my question, Does the SQL Standard mention trigger events on DDL (ALTER, CREATE, DROP)? I address the fact that many databases are addressing this need with ad-hoc functionality. Do we need one ...
12
votes
4answers
240 views

Deleting useless content from the site

Our site has a lot of good content with lasting value. It also has quite a bit of poor content - primarily old, closed questions that do not qualify for the automatic cleanup processes. To summarize ...
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 ...
2
votes
2answers
60 views

Are trivial questions 'too localized'? Any need to improve respective close reason message?

Update: I've deleted my answer on the referenced question. Now, it can be purged by delete votes or the Stack Exchange Roomba. I would like to understand better why How to upgrade pgAdmin 4 version 1....
8
votes
5answers
370 views

DBA's updated site theme is ready for testing!

As part of implementing the new unified themes across the network, we're gradually rolling out updated site themes for each site. As of today, we have enabled your updated site theme for testing. If ...
0
votes
0answers
12 views

Stackoverflow data model for new tags

I would like to know how Stackoverflow and StackExchange manage pre-defined tags tags and addition of new tags. Today, I tried to define a new tag, only to be met with this error message: Creating ...
8
votes
2answers
184 views

Removing the SQL tag

We have decided to burninate the sql tag by a clear majority (46 to 7 with 750 views): Let's burninate the SQL tag! It is now time to work out the details. I have added an answer below ...
6
votes
1answer
70 views

Purpose of change-tracking tag

I just saw a question about version control, where an edit has been suggested changing the tag from tools to change-tracking. My gut reaction was the the change-tracking tag was more about tracking ...