All Questions
827
questions
-9
votes
1
answer
74
views
How to know who performed downvote
Can someone please advise: Is there any chance to know who performed a downvote on my answer?
- 2,427
-6
votes
1
answer
93
views
Why was my question deleted
I have a question about my Database Administrators Stack Exchange post: What prevents me from using SQL Server Developer edition as production
so my question it's pretty normal and there's no other ...
4
votes
2
answers
73
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 ...
- 141
7
votes
0
answers
74
views
Can the edit button be hidden if I am unable to edit?
I keep trying to edit meta posts (often just to see how a specific formatting thing is done) but when I click edit it just tells me:
Could it be made more obvious that the post can't be edited by me? ...
- 123
4
votes
1
answer
55
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, ...
- 16.4k
6
votes
2
answers
71
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 ...
- 5,570
3
votes
0
answers
97
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?
5
votes
2
answers
98
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 ...
- 9,467
14
votes
2
answers
230
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 ...
- 6,297
14
votes
1
answer
210
views
Why is a moderator who has been around for 8 years a new contributor?
Today while I was reading a linked question on this answer, I found that Paul White, a moderator who joined more than 8 years ago and currently has around 55k reputation points and 900 posts, is ...
- 103
0
votes
1
answer
89
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 ...
- 78.9k
-7
votes
1
answer
99
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
1
answer
56
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 ...
- 101
2
votes
3
answers
64
views
Why cannot I VTC as a dupe, while someone else can?
This question came up in the VTC queue. It has been voted as having a duplicate already, but when I try to do the same, referring to the same duplicate, I'm not allowed to:
What am I doing wrong, ...
- 26.6k
0
votes
1
answer
34
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 | ...
- 16.4k
6
votes
2
answers
108
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 ...
- 9,467
5
votes
1
answer
244
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 ...
- 2,109
3
votes
1
answer
40
views
Could the editing limit if changing code syntax be reduced from 6 characters
I was editing this answer to change the syntax from := to = and I received a message saying the edit must be at least 6 characters.
Could this be changed if editing code syntax?
- 1,402
12
votes
3
answers
170
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 ...
- 5,570
9
votes
1
answer
85
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 ...
- 2,408
6
votes
1
answer
122
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 ...
- 163
8
votes
1
answer
148
views
Issues about the [unique-key] (sic) tag and its synonyms
I usually come across some questions that include the unique-key tag, and I consider that such an expression is redundant, since a KEY constraint (be it PRIMARY, CANDIDATE or ALTERNATE), by its very ...
- 8,540
-3
votes
1
answer
83
views
Vote to accept answer?
There are a number of great answers out there that have never been accepted as the answer for whatever reason. Would a new feature that allows high-reputation users to vote to accept the answer after ...
- 7,974
12
votes
8
answers
672
views
Community Promotion Ads — 2019 [duplicate]
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 ...
- 101
2
votes
1
answer
42
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
- 1,781
8
votes
1
answer
121
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 ...
- 101
8
votes
0
answers
92
views
Please use different color on 'seen' anchor tag
Until recently the color of Questions in the main pages of Questions of dba.stackexchange eg had had significance. Now a Question that I have opened is the same color as one I have not yet looked at.
...
- 78.9k
1
vote
2
answers
46
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 ...
- 26.6k
2
votes
2
answers
75
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 ...
- 357
6
votes
3
answers
132
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'...
- 23.8k
11
votes
0
answers
113
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, in ...
- 101
10
votes
2
answers
138
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 ...
- 9,354
3
votes
2
answers
68
views
Question with multiple tags - which tag gets credited?
If I ask a question with multiple tags on it, which tag gets "credited" with that question in the stats? On the tags page, do all the tags I use increase their count, or only one of them? If only one, ...
- 6,451
8
votes
1
answer
109
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 ...
- 101
5
votes
1
answer
128
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 ...
- 78.9k
1
vote
0
answers
46
views
Search broken? It's not returning results
why doesn't this show my latest answers with CREATE FUNCTION?
https://dba.stackexchange.com/search?q=is%3Aanswer+user%3A2639+%22CREATE+FUNCTION
It has three components,
is:answer
user:2639 (me)
"...
- 64.1k
6
votes
2
answers
53
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 ...
- 5,957
2
votes
1
answer
26
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 ...
- 64.1k
-3
votes
1
answer
60
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 ...
- 64.1k
5
votes
1
answer
111
views
Not dead yet! Repairing damaged external links
It seems sqlblog.com is now sqlblog.org 1.. One effect of this is to break outgoing links from dba.se.
In the past, I've tried to be a good netizen 3,4,5,6 and edit posts with dead links to an ...
- 4,861
13
votes
0
answers
262
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:
...
- 70.3k
2
votes
2
answers
66
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....
- 57
12
votes
4
answers
261
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 ...
Paul WhiteMod
- 88.1k
16
votes
1
answer
166
views
Please help us delete the SQL tag!
Continuing the process started in Let's burninate the SQL tag! and Removing the SQL tag.
It is time to work our way through questions that have only the sql tag.
Use the results of this SEDE ...
Paul WhiteMod
- 88.1k
0
votes
0
answers
14
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 ...
- 343
6
votes
1
answer
76
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 ...
- 11.7k
1
vote
1
answer
48
views
Make "log" a synonym of "transaction-log"
I propose making the tag log a synonym of transaction-log.
Looking at existing questions, most that use log have the meaning of transaction-log.
For those questions about a time-ordered, human-...
- 25k
9
votes
2
answers
282
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 ...
Paul WhiteMod
- 88.1k
14
votes
3
answers
502
views
Suggestions for a better headline graphic
An answer to DBA's updated site theme is ready for testing! suggests that the headline graphic ought to be more reminiscent of an ERD diagram.
Before:
Now:
In a comment, Catija asked us to come ...
Paul WhiteMod
- 88.1k
9
votes
5
answers
392
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 ...
- 101