We’re rewarding the question askers & reputations are being recalculated! Read more.
24

Similar ideas have been popping up on meta.SO. Popup requesting people to specify a DBMS when they tag a question with the tag SQL? sql tag without provided RDBMS I am all for it. My favorite would be to enforce the declaration of a basic (DBMS) tag. We'd need some sort of db-agnostic tag to go with that, but with simpler wording - many people won't ...


22

a table: |Item |Value| |--------|----:| |Computer|$1600| |Phone | $12| |Pipe | $1| a wide table: |Item |Value| |--------|----:| |Computer|$1600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000| |Phone | $12| |Pipe | $1| a table ...


17

You should flag the question as in need of moderator intervention. Moderators are able to migrate suitable questions to any destination. The belongs on another site close/flag shortcut exists for common destinations where migrating users on the source site are likely to be familiar with the on-topic rules for the proposed destination (no one wants to ...


16

While it might look like a good idea at first this has been suggested multiple times on the stackexchange meta: Would it be possible to have a “community accepted” feature? Community vote for “Accepted Answer” (Rep. >= 5000 only) Would it be possible to have a “community accepted” feature? The consensus seems to be that the number of up votes show the ...


15

I'll chime in here, seeing as I started the original discussion on chat. I think that the message is a good idea, but enforcing a base RDBMS tag (Oracle, SQL Server, Sybase, DB2. MySQL, Postgres etc) OR "RDBMS agnostic" might be a better way to go. Often the OP will post a question that will have a wildly different answer depending on which RDBMS they're ...


14

I migrated it and the migration was rejected: that's not a bad outcome for a question we aren't sure about, but the response I had in chat was: I'm not sure whether it is an ontopic question or not, but it fails to meet the "being a question" criterion :-) Which is a bit worrying - we probably only want to migrate those we are reasonably confident ...


13

I think a reminder is the way to go, given the proliferation of nosql-of-the-week and specific-version-of-oracle tags that you would have to curate if you wanted to enforce it. Also, it's not necessarily appropriate to enforce this on some questions on (for example data modelling). Even though the OP may have a specific platform in mind, this type of ...


12

Would it make sense to require a reason from a user when voting to reopen a question if they haven't made any changes to the question? This sounds intuitively like a good idea (more information is always better, right?) but: The review process should be simple. Either the question is good (enough) for the site (Reopen), or it isn't (Leave Closed). If you'...


11

This has been implemented by the community team.


11

No. This tag (well, specifically, homework) used to exist on StackOverflow. It was removed because it seemed to incite a lot of negative reaction, like "do your own homework!" There was a massive negative connotation against all of these questions because, presumably, a student shouldn't have to ask a peer network how to solve a problem they most ...


10

We could instead create a canonical question (or reuse an existing one as canonical) and close other questions as its duplicates. Perhaps this recent answer could serve as a starting point for – if not actually be – the canonical one: The wording on this error might as well be: ORA-00600: "Something" is broken in the database. It "...


10

ORA-00600 errors can be solved as: Go to https://support.oracle.com. Search for the error using the ORA-00600 lookup tool (the first argument between [...]), or a generic search as ORA-00600 + first argument, look at the list of notes and bugs related to your case. If you found a relevant bug/note, apply the patch or workaround. If you found a relevant bug/...


9

Yes. Yes it should. This would be incredibly helpful.


9

I've enabled this, but there are some caveats, so please keep them in mind: The default highlighting language is SQL. NOT auto-detect. If you ever want some other kind of syntax highlighting, you'll need to specify it explicitly (using the comment hint) or adjust the tag defaults accordingly. Syntax highlighting is enabled by default. So in places where ...


9

Finally get back around to this...This is just expanding on what is already within the Help Center > Asking itself. How do I ask a good question? We'd love to help you. To improve your chances of getting an answer, here are some tips: A Title is the first thing they will see The title of a question is going to be what draws folks to your question. Think ...


8

An alternative, not so nice but simpler, would be to have css line-height: 1 set for code blocks (.post-text pre { line-height: 1; }) on dba.se. Unicode tables like this would then not have broken lines: values ('Donald Duck') , ('Micky Mouse'); ┌─────────────┐ │ column1 │ ├─────────────┤ │ Donald Duck │ │ Micky Mouse │ └─────────────┘ so they ...


8

My personal feeling on this is that the title in question is fine. Those are SQL keywords and in most circumstances are capitalized. The capitalization in the title makes it clear we are comparing two T-SQL commands, not just the concepts. That being said I would find it acceptable to rewrite the title to use more natural language, i.e. What's the ...


8

SQL Sentry Plan Explorer (PE) can anonymize queries: There are limits though, and you will need to be careful to ensure that the anonymized code is still useful in the context of your question. I don't think PE will fully anonymize complex scripts with extensive DDL, for example. Other people might be able to make suggestions for that. Please make sure you ...


8

Originally, unique-key was set as the master for unique-constraint and unique-index because it was by far the more popular tag, and the only one with any usage guidance. There may be semantic differences, but it did seem like the tagged questions were all asking about essentially the same thing. To put it another way, the master tag was enough to help ...


8

Until a user has earned the Edit Questions And Answers privilege, suggested edits need to be at least six characters, and preferably many more than that. This may seem like an unfair restriction, but we want people learning to use the site to follow the advice in Why can people edit my posts? How does editing work? Edits are expected to be substantial and ...


7

I have to disagree with the currently accepted answer. This is a Wiki site, but there is more than one possible, valid answer for most of the more complex questions. It helps to keep different answers from multiple authors separate: To see when each was posted easily, without having to study the edit history. To have separate votes on multiple alternatives, ...


7

Always remember that tags are intended to make it easier to find a question, not to find the most Type-A classification of questions. You get 5 of them. I expect it would be easier to just tag with the OS involved if you need to narrow it down.


7

Would it be possible to remove the dash? Sure. Renamed big-table to bigtable for you.


7

Requiring a user to register doesn't actually add that big of a barrier for new users to ask questions and to provide answers. It also doesn't do much to encourage them to play by the site rules. What DOES help is proper community interaction. Poking them to clean up their questions and informing them WHY their answer isn't a good answer, while ...


7

log is a useless tag (as is logs), but looking at the questions it does not seem to be safe simply to make this a synonym of transaction-log. A good number (perhaps most) of the questions should be retagged using the following (mostly MySQL-specific) tags: binlog slow-log error-log archive-log (these tags also need usage guidance). For example (just from ...


6

As suggested in chat by Shog9: In the meantime, try Top Bar for Chat Rooms (stackapps) Provides a fully functional top bar, including realtime notifications, easy chat server switching, and fast room list searching, at the top of all chat rooms. Keep tabs on your inbox and site activity while chatting. For installation steps see ...


6

I have added default style selections to a few of the tags that had no selection before. Let me know if there are others that appear to need styling. Styling was added to the following tags: sql mysql stored-procedures Moderators do have the ability to change the default lang for highlighting per tag - just visit the tag info page: https://dba....


6

I think this is a great idea -- if you haven't already, I suggest a diamond mod editing this addendum into the DBA FAQ. https://dba.stackexchange.com/faq I do see but this is not the right place to ask questions about... client-side programming (ask on Stack Overflow instead) basic SQL (ask on Stack Overflow instead) Is that what you had ...


6

I do like the idea, however it has been declined multiple times by the network at large. I think this is the canonical post: Make links posted by users open in a new window And I'm not 100% certain, but I suspect we couldn't get an exception for our site. Because so many other sites don't bother to do this, I've become quite accustomed to right-clicking ...


6

You can use some of the advanced search options for this. Run a search for: user:me hasaccepted:no


Only top voted, non community-wiki answers of a minimum length are eligible