All Questions
815
questions
4
votes
1
answer
108
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
781
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 ...
0
votes
2
answers
137
views
Can I find out why this question was deleted?
Can I find out why this question was deleted and whether there are changes that could allow it to be undeleted? I have found an answer and would like to post that.
https://dba.stackexchange.com/...
1
vote
2
answers
128
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
170
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
103
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
127
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
128
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
172
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
161
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 ...
3
votes
2
answers
140
views
How do I put hard returns/line breaks in my questions on this site?
I've posted a few questions with code on this site. Each time I have written the code with appropriate line-breaks. But when I post the questions the line-breaks disappear, and all the code ends up on ...
1
vote
2
answers
120
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
106
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
193
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
301
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
374
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
236
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
236
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 ...
11
votes
2
answers
221
views
Are we on the same page with [pagination] and [paging]?
I just logged in a duplicate suggestion to make "pagination" a duplicate of "paging":
paging has 53 questions, pagination currently only 4.
But then I felt, the term "...
4
votes
2
answers
221
views
Why isn't AWS's sponsoring being shown on Database Administrators Meta?
Has this been just forgotten or is it intentional?
My thoughts are that if you sponsor the site, then it should be shown on the Meta site as well.
See more at: AWS will soon be sponsoring Database ...
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
1
answer
113
views
How does the Community bot close questions after just a single VTC?
This question was VTCd once as a duplicate, and then promptly closed by the Community bot. Ordinarily one would need four votes for the question to be closed. Alternatively, it would require the voter ...
2
votes
2
answers
92
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
62
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
111
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 ...
8
votes
0
answers
44
views
Delete comments in review queues
I was reviewing the Close queue when I saw one of my comments. (Please tag your DBMS, version included). I was about to delete it when I realized that it is not allowed while you are in reviewing mode....
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.
8
votes
0
answers
76
views
Remove 5 seconds delay to flag comments
Few days ago I was encouraged by a Mod to review and remove the unneeded comments as a maintenance task.
FYI, and this goes for everyone, if you have spare cycles it would be appreciated if you could ...
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? ...
5
votes
1
answer
54
views
Spurious double grant of "Steward" badge
I noticed that I have just been granted "Steward" badges a second time:
I guess that is a bug that should be fixed.
Edit: for the record – this has been fixed.
6
votes
1
answer
85
views
Magic-link for "Text please, no screencaps"
Can we please get a magic link to refer posters to guidance around using text snippets instead of screencaps or other images.
https://meta.stackoverflow.com/questions/285551/why-not-upload-images-of-...
7
votes
3
answers
105
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
178
views
Markdown issue with # in PostgreSQL code
In formatted SQL code, the Postgres operator #> is currently misinterpreted as comment sign, which results in confusing display. Happened here:
Dynamically update JSONB rows - POSTGRESQL
I can ...
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/...
9
votes
1
answer
116
views
Can dark mode be enabled in dba.se?
It it not possible to set dark mode in dba? In stackoverflow, it is possible.
Please enable it!
I have an eye cataract and the white mode hurts my eyes!
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 ...
0
votes
1
answer
38
views
Feature Request EOL Tags
Feature Request for Tags
Some of the tags used on DBA.SE (and possibly other sites) are related to a specific version of a product or exist as part of a certain product. It would be nice to have a ...
0
votes
0
answers
40
views
Review menu shows red dot, but is empty (again)
Iz is basically like here New Review Queue: Faulty Red Dot!
But the queues are all empty
But as the the question above is from 2017 it is a new problem probably
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 ...
3
votes
0
answers
31
views
Why does the search function not work as advertised?
When you click in the search bar it shows you these hints:
I take to understand the highlighted one as this: the phrase in double quotes will search for the exact quoted literal.
Not so, as the ...
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, ...