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

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

This has been implemented by the community team.


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 "recently&...


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


10

The question doesn't make an explicit case for the new tag, beyond continuing the line of existing Windows Server version tags. So, this seems like a good time to look at the utility of the whole hierarchy. The FAQ describes the reasons for tagging questions: Tags connect experts with questions they will be able to answer. Tags are for sorting your ...


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


8

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


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

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

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

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

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


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

No. This was a good edit suggestion. Having multiple answers that address part of the question is not preferable to having one good, collaboratively-improved answer. This is a wiki site, after all.


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