All Questions

The following question was migrated from Stack Overflow: iTunesConnect Error: “Unknown app version” The source of the migration is a revision of an answer. What gives?

Recently I learned "Magic Links" are a thing Paul White: Magic links now work e.g. [mcve] and [example] and [repro] for the new help page Jul 10 9:45 PM This is awesome, but I have a nagging ...

Today I'm handing back the diamond you gave me in 2011. Some of you will not understand or agree with my reasons for doing so, but the nature of the community we have on this exceptional site leaves ...

During review, I see that a lot of people vote to close questions as “too localized” when I would think they are actually too broad. One example is here. There is no typo, basic error, ...

I saw this question today and it was rightfully put on hold because it was cross-posted to stackoverflow (where it already had an answer anyway). However, one poster told the OP that "Besides, this ...

Microsoft's Windows Server Update Services product (WSUS) makes use of a database, which unfortunately performs very poorly. There is a third-party script available that modifies the database (I ...

Problem A bunch of my own comments (OP) and some from someone else all disappeared recently from the this post. I know that moderators can delete comments, but in this case I do not believe they ...

there is a silver badge called census that is linked to a survey. where can I see this survey?

The question Can I update my Microsoft Enterprise SQL Server? was migrated from stackoverflow.com and then rejected. If I understand the Auto delete rules correctly it will be deleted in about 30 ...

According to Answer appears automatically converted as a comment on meta.se: Trivial answers containing a link to another question in the network are automatically converted to comments on the ...

Can someone please advise: Is there any chance to know who performed a downvote on my answer?

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

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

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

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

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

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?

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

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

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

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

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

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

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

Often times I need to represent data in a way similar to this one: ...which is: +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | ...

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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