All Questions

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 ...

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 ...

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) "...

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 ...

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 ...

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 ...

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 ...

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:...

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....

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 ...

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 ...

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 ...

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 ...

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-...

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 ...

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 ...

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 ...

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)...

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

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 ...

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 ...

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 ...

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

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 ...

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 ...

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 ...

What information should be provided when asking how to improve the performance of a query?

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

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 ...

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 ...

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 ...

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 ...

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 ...

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,...

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 ...

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 ...

May I know if there is any limit/ restriction on the number of questions posting on this site?

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 ...

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 ...

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 ...

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?

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 ...

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

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...