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.
571
questions
-2
votes
0
answers
19
views
Learning Resource Needed: How do popular databases store their data on disk? [closed]
I started a project about trying to create my own simple DBMS using C# and Java. I created a simple SQL-like language which I called RTQL(Rudimentary Testing Query Language). This "thing" ...
4
votes
1
answer
135
views
Is it ok to add an answer for a later software version?
Sometimes I see questions tagged sql-server-2005, but I have an answer for a later version, like sql-server-2019. Things have changed and it works in a slightly different way.
Is it ok to add an ...
25
votes
1
answer
799
views
Ongoing Moderation Strike
Since Monday, June 5th, 2023, moderators and content curators (that's you, dear reader) from across the Stack Exchange Network, including the moderation team on this site, have decided to protest ...
1
vote
2
answers
144
views
Is asking about a list of the rules determining effective permission in SQL Server within the scope of the site?
Would the following question be within the scope of the site?
I've been struggling to find a listing for the rules that determine
the effective permissions of a user on a database object in SQL ...
0
votes
0
answers
180
views
Middle Sidebar Advertising
As you all know, advertising is an important source of revenue for Stack Overflow and it helps us support all the sites across the Stack Exchange Network and the resources that go into maintaining and ...
-4
votes
1
answer
122
views
Why was the Spam flag declined when the user was blatantly recommending his software of the same name
What does a RED X on a database user mean?
I can't see it anymore but I am sure that I had marked Esrim's reply as Spam because he/she was recommending software of the same name as his.
I was ...
2
votes
2
answers
141
views
Why was a question about AWS RDS / Postgres permissions model closed?
Can I get some feedback on how / why this one was off topic:
What permissions are needed to prevent ERROR: permission denied for tablespace pg_global in RDS?
It's not clear to me whether I've ...
0
votes
1
answer
142
views
Downvoter targeting questions so that they get removed by Roomba
A downvoter has been targeting questions so that they get removed by Roomba. I don't know whether only my questions are targeted. Examples:
History of the provisioned write capacity in DynamoDB ...
4
votes
1
answer
180
views
What's an appropriate edit to an old post containing links to old documentation?
See this edit for an example: a four years old question contains a link to the then-current documentation. The world has moved on since, and someone changes the old link to point to the new ...
0
votes
1
answer
178
views
What is the appropriate tag to use for "database"?
I just asked a question What columns are needed to list the database, schema and table a record comes from? which asks about which 'database' a row comes from in a cross database/schema question and ...
6
votes
2
answers
1k
views
Are ChatGPT answers allowed here?
I know that ChatGPT is banned on Stack Overflow.
Lately, I saw an increase of answers by ChatGPT .
Join twice on same table with different conditions and no PK / FK relations
Get table data not in ...
2
votes
0
answers
79
views
2022: a year in moderation
As we say goodbye to the old year and welcome the new one, we have a tradition of sharing moderation stats for the preceding calendar year.
As most of you here are aware, sites on the Stack Exchange ...
1
vote
2
answers
123
views
Possible up-vote abuse?
The question I came across in New Question queue, looked so horrific I didn't dare rate it; I just put in my rash opinion as a comment. I glanced at it later, and it had 2 up-votes. Knowing a bit ...
0
votes
0
answers
108
views
How can I improve my question? [duplicate]
Question here.
I did my best to follow Stack guidelines:
The question is formatted nicely with code and tables in appropriate forms. Where possible, I pared these down to just the relevant ...
0
votes
1
answer
194
views
Canonical community QA for index usage troubleshooting
Is there already a canonical QA for troubleshooting why an index might not be used, even though the index exists? If not, is there an appetite for one? Should it be per-DB flavor or generic?
The ...
0
votes
1
answer
310
views
Please add a tag for griddb
I am seeking help to create a tag for griddb. Please check ( Tag Info ) on SO. I have posted question on DBA.SE that would cover in griddb tag. Currently I have used query tag because that's the ...
14
votes
3
answers
378
views
Is it healthy for the community to have the same user asking so many questions daily?
Recently I've seen a user asking 13 questions (most of them with a negative score) in a row for a specific tag and that gives me the impression that the user is overflowing the queue leaving other ...
3
votes
1
answer
237
views
Is providing a cash bounty acceptable on dba.stackexchange.com?
We're trying to import (reverse engineer) some data from someone else's MS SQL database, without any vendor support.
We're Happy to pay a $200 USD cash bounty to anyone that can solve this in a ...
10
votes
2
answers
238
views
Should I vote to "move to Stackoverflow" on SQL questions?
I often encounter questions that ask for help with writing SQL, and I usually vote to move them to Stackoverflow, because that is about programming in my book. But I have the feeling that mine is not ...
10
votes
0
answers
140
views
2021: a year in moderation
As we say goodbye to the old year and welcome the new one, we have a tradition of sharing moderation stats for the preceding calendar year.
As most of you here are aware, sites on the Stack Exchange ...
0
votes
1
answer
123
views
Should we add a new [Oracle-21c] tag?
Does DBA SE need a new Oracle-21c tag?
I see tags for older versions of Oracle. But I don't see one for version 21c.
2
votes
2
answers
93
views
Why would such a question get a downvote
I asked this question yesterday and I think it's pretty clear what I'm focusing on but it got downvoted.
Please can someone explain what's wrong with the question and how I should improve it so I ...
3
votes
1
answer
64
views
which is considered as Basic SQL
which is considered as Basic SQL :
I have read the help of the site mainly this:
https://dba.stackexchange.com/help/on-topic
and it is not clear to me: can they exemplify?
for example I want to ask a ...
9
votes
0
answers
569
views
AWS will soon be sponsoring Database Administrators
We're excited to announce that AWS will be sponsoring Database Administrators beginning September 27, 2021 through December 31, 2022. We wanted to give you a heads up and walk you through what it will ...
8
votes
2
answers
114
views
Revisiting upsert vs merge
Back in 2013 we decided that upsert and merge are two different things and questions about such should be tagged separately.
Today Postgres has insert ... on conflict, and upsert has mostly historical ...
4
votes
1
answer
45
views
Why has 'last seen' been removed from display of user profiles?
When trying to assist someone, it is helpful to know the last time they visited your dba.stackexchange.com or stackoverflow.com or other sites managed by your various offerings.
Thank you for the ...
-5
votes
1
answer
112
views
Why would we ask questions if they are just going to get downvoted? [duplicate]
Title says it all. What the [REDACTED]?
-2
votes
2
answers
67
views
Post for a free webinar
I would like to know if I can write a post to promote a free online webinar about database training in this Database Administrator community.
7
votes
2
answers
65
views
Should we flag an answer for deletion if it is essentially the same as an earlier answer?
If Alice answers "reverse the polarity" in January, and then in July Bob answers with "try reversing the polarity," should we flag the second for moderation action and deletion? ...
7
votes
3
answers
106
views
Do we need a special vendor-neutral tag for columnar databases (tables)?
This question is inspired by the discussion here and in the chat. Different vendors use different but similarly sounding terms for their respective implementation of columnar databases and tables. It ...
11
votes
1
answer
135
views
Content stolen/scrubbed from SE
Almost immediately after I answered my own question
google offered it as a search result, but from a totally different site and under a strange name "Jessica Alba": https://www.onooks.com/...
0
votes
2
answers
37
views
Does Pioneers in Database Research have enough significance to warrant a Historical Lock?
I recently came across a question from the nascent era of Database Administrators; it was posted in August of 2011. At that time, the details about what constituted a good question, and what did not, ...
2
votes
1
answer
44
views
remove tag [mysqlf] [duplicate]
There is this question which has the tag
mysqlf
As i can't figure out what mysqlfcan be, in my opinion it is only a typo and should be as such removed.
The linked question is also the only one that ...
5
votes
2
answers
90
views
Is it worth to reopen an old question that has already been answered?
I have just edited the question Query using LEVENSHTEIN function returning more results than expected [closed] which was already answered before being closed a long time ago (motive: question needs ...
24
votes
3
answers
177
views
2020 Community Moderator Election Results
Database Administrators's fifth moderator election has come to a close, the votes have been tallied and the new moderator is:
They'll be joining the existing crew shortly—please thank them for ...
7
votes
2
answers
75
views
What contributes most: a long answer with more than one way of doing a task or a short answer with the method known to be more professional?
I answered this question using a method that looked ok and solved the user's problem. But later a more experienced user added a comment showing a method that is the solution "by design" and ...
1
vote
0
answers
90
views
2020 Community Moderator Election
The 2020 Community Moderator Election is now underway!
Community moderator elections have three phases:
Nomination phase
Primary phase
Election phase
Most elections take between two and three weeks, ...
4
votes
3
answers
386
views
2020 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 ...
8
votes
8
answers
187
views
2020 Moderator Election Q&A - Question Collection
The purpose of this thread was to collect questions for the questionnaire. The questionnaire is now live, and you may find it here.
DBA is scheduled for an election next week, October 12, 2020. In ...
4
votes
2
answers
42
views
You can accept your own answer tomorrow
So I have this Q and somebody else had a nice A. Didn't exactly solve my issue, but put me on the right track. I upvoted their answer and was prompted immediately by the site to consider marking the ...
3
votes
2
answers
31
views
You can only post once every 40 minutes
In both https://dba.stackexchange.com/ & https://dba.meta.stackexchange.com/, I tried to post a new question. After I clicked Post your question, the system said A question with that title already ...
11
votes
3
answers
287
views
Sensitive Words policy
Recently in the Suggested Edits Review Queue, there was a spate of edits changing only master/slave verbiage to primary/secondary.
In the absence of other improvements to a post, should we accept or ...
-7
votes
3
answers
264
views
Why do people "answer" without reading the question here?
It happens again and again. No matter how crystal-clear I am, explicitly mentioning things, the answers/comments will clearly show that the person typing them did not read the question. They either ...
-5
votes
3
answers
118
views
Is a display name sufficient disclosure?
I just raised a flag for "moderator attention" on this answer with the following message
This answer from a Microsoft employee recommends Azure without any kind of disclosure of conflict of ...
15
votes
1
answer
112
views
Top Answers, anyone transferring Q&A?
I just became aware of https://topanswers.xyz/databases via a conversation on a sister SE site. I see several familiar names over there. I have not really looked around much, it is different but it ...
-1
votes
1
answer
40
views
AppArmour question - why was it closed?
This questions was recently closed:
MySQL was stopped
As you can see, the close notice says it's off-topic and too localized.
Does that mean all questions where the problem turns out to be related ...
-2
votes
1
answer
41
views
Would an "all-servers" tag be appropriate/welcome?
I'm planning on asking a question.
Now, while I plan to put PostgreSQL as the "major" server for the question, there is no reason (and I am interested) that replies for other servers couldn't be ...
0
votes
1
answer
54
views
Possibility to use typesetting on Database Administrator site [duplicate]
Though not daily, from time to time it would be really nice to be able to use typesetting (like MathML, Latex, etc) to be able to express formulas etc for theoretical stuff.
In the long run, I think ...
-11
votes
3
answers
191
views
Time vindicates those that are right and righteous, like me
I just wanted to share a story, my narrative on this network.
In Sep 27 '17, I asked a question about how SQL Server implemented GREATEST and LEAST. This question was largely rejected by the network. ...
9
votes
1
answer
77
views
Can we merge the tag [database-trigger] into the tag [trigger]?
I think the tags trigger and database-trigger means the same thing.
I suggest we merge database-trigger into the tag trigger.