All Questions
816
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" ...
- 111
7
votes
3
answers
114
views
Should we add answers when the best answer already exists?
I'm not suggesting we game the system, but one of the Area 51 metrics that will be evaluated at the end of the beta is the answer ratio described as:
2.5 answers per question is good, only 1 answer ...
- 111
0
votes
2
answers
161
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/...
CommunityBot
- 1
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 ...
- 16.1k
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 ...
- 172k
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 ...
- 62.1k
30
votes
3
answers
4k
views
Asking query performance questions
What information should be provided when asking how to improve the performance of a query?
- 172k
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 ...
- 101
-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 ...
Paul WhiteMod
- 82.9k
10
votes
2
answers
172
views
Would question about database recommendation be on topic?
I am developing desktop application that will need a database. App will only run on Windows.
My problem comes from not being able to afford SQL Server Enterprise Edition, and Express Edition has ...
- 35.1k
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 ...
Paul WhiteMod
- 82.9k
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 ...
Paul WhiteMod
- 82.9k
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 ...
Paul WhiteMod
- 82.9k
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 ...
- 69.7k
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 ...
Paul WhiteMod
- 82.9k
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 ...
- 101
3
votes
2
answers
143
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 ...
- 17.4k
3
votes
0
answers
69
views
Can the color scheme for similar questions be changed?
Can the orange on yellow color scheme for matching/similar questions be changed.
The contrast between the two colors is low.
I see a similar question Which color to chose for the dba.exchange site? ...
- 2,201
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 ...
Paul WhiteMod
- 82.9k
3
votes
0
answers
193
views
So what's with the hats thing?
You may have noticed some of our users now have hats around the site, and it might almost be annoying, but we assure you they're all in good fun, and intended to increase site participation!
Here's a ...
- 2,201
8
votes
1
answer
172
views
I just got two hats, why?
I just received two Hats, but I'm not sure what I did to get them.
Not that I don't want them, just curious. Especially since I got them on a site I'm not too active on.
Following are the Hats:
Just ...
- 100
9
votes
4
answers
287
views
Community Promotion Ads - 2013 [duplicate]
As it is December 2012, we are now going to reset our Community Promotion Ads for the new year. Funny timing, this is exactly 400 posts later.
What are Community Promotion Ads?
Community Promotion ...
- 2,201
5
votes
3
answers
88
views
Do we need to convert FAQ questions like this to Community Wiki?
Here is a sample question. What is Clustered Index?
I think this should be a community wiki question, because PO not pointing any particular issues, just want explanation!
I'm not sure to make it as ...
- 2,201
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 ...
- 109
67
votes
1
answer
5k
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 ...
- 76.9k
15
votes
4
answers
596
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 ...
- 41
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 ...
- 25.1k
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 ...
- 101
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 ...
- 38.8k
40
votes
1
answer
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 ...
- 69.7k
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 ...
- 69.7k
1
vote
1
answer
217
views
DBA Stackexchange bug
Looked in the help section to figure out where to post a bug report, it's minor but still.
The candle icon for "Achievements" has a bug at least for my account where there is +12 rep for Stack ...
- 100
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 ...
- 100
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 ...
- 100
11
votes
2
answers
279
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 "...
Paul WhiteMod
- 82.9k
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 ...
- 101
29
votes
11
answers
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/...
- 1,447
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.
Paul WhiteMod
- 82.9k
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 ...
Paul WhiteMod
- 82.9k
9
votes
2
answers
262
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 ...
- 2,759
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 ...
- 4,586
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 ...
Paul WhiteMod
- 82.9k
11
votes
1
answer
199
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 ...
- 172k
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 ...
- 25.1k
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 ...
jcolebrandMod
- 6,345
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....
Paul WhiteMod
- 82.9k
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 ...
- 69.7k
34
votes
3
answers
460
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 ...
Paul WhiteMod
- 82.9k
14
votes
2
answers
441
views
Is the comment-only answer acceptable?
I've just read a post that's really mundane. It's one of those "just read the error message" type questions. There's an obvious, correct, and incredibly trivial answer I can respond with; ...
Paul WhiteMod
- 82.9k