All Questions

8
votes
1answer
75 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
81 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 ...
1
vote
0answers
37 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) "...
5
votes
2answers
43 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 ...
2
votes
1answer
16 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 ...
-2
votes
1answer
38 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 ...
4
votes
1answer
67 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 ...
13
votes
0answers
199 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:...
2
votes
2answers
48 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....
12
votes
4answers
216 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 ...
15
votes
1answer
129 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 ...
0
votes
0answers
9 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 ...
6
votes
1answer
69 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 ...
1
vote
1answer
33 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-...
8
votes
2answers
157 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 ...
12
votes
3answers
354 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 ...
6
votes
5answers
345 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 ...
5
votes
1answer
61 views

Can we reopen this question?

There is a question by Evan Carroll about the origins of "sargable" that initially had received some "tough love" and got closed as off-topic. I was among those who voted to close it (as too localized)...
0
votes
0answers
35 views

I am not having a response for my question

No comments, no edits, no answers. How can I show up my question to potential users and get responses? Link for my Question
9
votes
1answer
33 views

How to tag MariaDB questions that also apply to MySQL

I'm using MariaDB server 10.3 currently at my job, which so far has successfully been a direct drop-in replacement for MySQL 8 (I use the MySQL 8 documentation as my reference when managing our ...
4
votes
2answers
54 views

can i ask questions here about ElasticSearch?

I'm doing lots of development with ElasticSearch and I have lots of questions. Can I ask those questions here? Example of things off the top of my head: does elastic store the timezone when you ...
6
votes
3answers
113 views

Closing questions as off-topic when they belong on our site

Over the past couple of days I have noticed questions that have been flagged as needing to be closed or migrated to Stack Overflow because these questions contain code or not direct questions about a ...
-3
votes
4answers
42 views

Can we tag 2 right answers?

For example, in this post: What is the best way to put commas into large numbers both answers are right, but slightly different.
4
votes
1answer
39 views

How to add conclusive information to a question - after it has been answered?

The other day I asked a question that I have been struggling with for some time. when the question was answered, before I accepted the answer I tried it. After that I wanted to show the world, and ...
4
votes
1answer
42 views

what could be an acceptable way to add a fix to an accepted answer?

I have a question regarding calculating the space used by a table, indexes, etc. Someone just used the scripts they got from the beautiful answer to that question, and noticed it did not work for sql ...
41
votes
7answers
880 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 ...
12
votes
1answer
121 views

Asking query performance questions

What information should be provided when asking how to improve the performance of a query?
-1
votes
3answers
33 views

Where Are Units and Values Specified in Questions and Answers

When describing the unit (e.g. GB) of a value (e.g. 32) in questions or answers where should the unit be placed?
2
votes
0answers
30 views

Creation of a DBA.SE-flavored Minimal, Complete, and Viable Example page [duplicate]

All too often I see questions that are vague and just outright difficult to understand. I try to send the OPs to Stack Overflow's MCVE page, but that doesn't seem to work often enough and I wonder if ...
7
votes
3answers
146 views

declined very low quality post (-5 votes and deleted)

A flag for very low quality post was declined. -5 Performance tuning for MySQL database (read only) answered Jul 3 at 15:53 by XXX With the reason: declined - flags should only be used to ...
7
votes
2answers
120 views

Is the comment-only answer acceptable?

Today I ran across this question, which I think is a pretty good example of a situation where a full answer may not be warranted. It was a bit messy in the original edit, but there was a correct (if ...
11
votes
2answers
66 views

Add Licensing questions as off-topic on help/on-topic page?

I've seen this question covering why we don't need to add an explicit VtC option to covering licensing questions. However, it would seem to make sense that, if we're going to close questions about ...
7
votes
3answers
52 views

Separate tag for [set-returning-functions]

I noticed that set-returning-functions has been made a synonym of functions. (Paul White♦, Sep 29 at 13:33, if I read https://dba.stackexchange.com/tags/synonyms correctly. I am not too happy with ...
4
votes
1answer
23 views

Is there a redirect bug on migrated questions?

I have spotted a strange behaviour and I think it is a bug. I have found this question: https://stackoverflow.com/questions/50836364/what-is-the-solution-of-these-errors I have made it not clickable,...
0
votes
1answer
59 views

Should we allow non-standard alternatives for standard syntaxes?

There are a lot of very minimal things that we can rewrite with the same effect >99% of the time, two of which come to mind are Non-standard syntaxes for Identity Columns for databases that support ...
-4
votes
2answers
97 views

Renewing the “basic” discussion

It was reviewed quite extensively on meta. This debate is years old. Can we get a resolution on this? I came to the site far after the question was initially presented. In fact, it was already ...
0
votes
1answer
26 views

Is there a limit to ask question per day or per week?

May I know if there is any limit/ restriction on the number of questions posting on this site?
1
vote
1answer
26 views

A “draft-box” facility

Would it be possible for users to have a draft (i.e. save before posting) facility on the site? I frequently find myself interrupted in the middle of answers and am obliged to abandon my efforts and ...
6
votes
0answers
28 views

Pinning/sticking good (canonical) questions/answers to top of board

I was wondering whether it would be a good idea for moderators (based on popular demand) to be able to pin/stick posts at the top of the meta questions list (as is done here). Two posts that I would ...
4
votes
1answer
86 views

How to edit my question or is it too localized?

I have a question which was marked as too localized. I understand that it looks very specific and I have workaround, but it is unclear the reason why that happens and also someone else can have the ...
-3
votes
1answer
30 views

how to ask question to a particular person for example “xxzz” who is as sql server developer

how to ask question to a particular person for example "xxzz" who is as sql server developer. Actually I want to ask a question directly to a person who answered my previous question . Is it possible?
9
votes
0answers
182 views

Minimal, Complete, and Verifiable Example

How to create a Minimal, Complete, and Verifiable Example for database-related questions Database-related questions asking for practical advice will get the most helpful answers if they provide a ...
5
votes
1answer
45 views

How to rate someone who answered my query?

How to give badges to other . actually I asked a question at you site and I got my answer, now I want to thank him by giving him some rating or badge like that
-6
votes
2answers
100 views

Why do people get credited for editing questions?

I am getting very annoyed with people editing my questions for no reason other than to satisfy their own ego. The changes make no material difference BUT mean I have to keep rolling them back. Why ...
4
votes
1answer
65 views

Should DBA.META.SE Have a Featured And/Or FAQ Tag

Based on Max Vernon's recent Meta Post request for a MCVE Page in the Help Centre on DBA.SE I initially posted an answer with an alternative idea for making information visible. Because I changed my ...
13
votes
2answers
130 views

Add an MCVE section to our help page?

StackOverflow has a great page in their help section on how to create a minimal, complete, and verifiable, example (MCVE). I think it would be very helpful if we had a similar document showing how ...
36
votes
1answer
685 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 ...
13
votes
8answers
362 views

Is this ageism or acceptable humour?

A recent question on the site, which otherwise uncontroversial, on-topic and interesting (and which has already got two in-depth answers), starts off with an attempt at humour which has resulted in a ...
8
votes
3answers
108 views

Helping new users write good questions

Background Some new users struggle to write a good question first time around. We already help in comments (e.g. by linking to helpful resources) but this does not always result in the question being ...
-1
votes
3answers
86 views

Tag rename [ansi-sql-standard] to [sql-standard]

The standard, though originally ANSI isn't really ANSI anymore. In fact, I imagine far more people develop it from the ISO/IEC outside of ANSI. ANSI calls it ISO/IEC 9075-4:2016, and the ISO/IEC make ...

15 30 50 per page