Hot answers tagged

24

Yes dba should be burninated because it... Isn't useful to connect experts in a topic area to questions they can answer Doesn't help describe the content of the question Doesn't add any meaningful information to the post Is ambiguous in that it could refer to the person or the role of a DBA Is simply the (abbreviated) name of the site


19

Yes database-administration should be burninated because it... Isn't useful to connect experts in a topic area to questions they can answer Doesn't help describe the content of the question Doesn't add any meaningful information to the post Is ambiguous in that it could refer to the person or the role of a DBA Is simply the name of the site


17

For one, I think yes. The tag itself doesn't add too much value to a question: if it is a good question, then we are happy, if it is not, then appropriate measures should be taken, no matter it's a homework or not.


17

No. I do acknowledge that generally it should be easier to understand what the question is about when the tag shows the full name of a product than when it shows an abbreviation. However, in my view that argument's weight is lessened in this specific case by the fact that the SSMS abbreviation is fairly well-known in the SQL Server world. And we do show the ...


16

No, I think this is quite similar to: Should there be a tag for classroom help? (Note that while the homework tag exists, it is only because it is very infrequently used and the moderators here have not bothered to abolish it - it has certainly been vanquished on SO.) Just because the OP is a newbie does not mean that the answer should be any different; ...


15

I personally think sql should be removed, as the majority of people posting questions on Database Administrators and Stack Overflow are targeting the specific RDBMS that they are working on. It's just human nature to tag - since you type sql, this tag is the first to appear. Also, the wiki definition of sql states: Structured Query Language (SQL). For ...


13

Yes, I think it should, thanks for bring it up. I've done the merge and created the synonym: https://dba.stackexchange.com/tags/restore/synonyms


13

Probably not. There's ansi-sql-standard if anyone is truly looking for that.


13

I agree. The sql tag is just too generic. Having the following tags should be sufficient enough to tag questions correctly with whatever Structured Query Language Dialect/Programming Language is being used: sql-standard (ANSI) plsql (Oracle) t-sql (Microsoft SQL Server / SAP Sybase) plpgsql (PostgreSQL)


12

Yes The only justification for the synonym I could find was in the answer to Why is "query" a suggested synonym for "sql"?: Simply because when the site was young, we repeatedly had folks posting questions about "query" when they really meant "help me with my sql" and don't understand the esoteric differences of the ...


11

You can certainly use an ETL tool to populate something that isn't a data warehouse - for example I'm currently working on a process that de-duplicates data and populates a CRM system. I'd call it an ETL process. Looks like a duck, quacks like a duck. However in the case of the question that the OP is referring to, the task the poster seems to be trying ...


11

I think sql is a perfectly valid tag. Many questions here are not concerned with the Structured Query Language. In fact, I just skimmed the latest questions rolling in and the majority is concerned with other things, like DB design, protocol questions, replication, etc. NoSQL DBs are also on topic here: MongoDB, Cassandra, CouchDB etc., where the tag is ...


11

I don't have very strong feelings about this, but on balance I think it is OK to create this tag. Some factors that I considered before making that statement: We did have an ola-hallengren tag before, but as I recall it was only applied to a very small number of questions. It was auto-deleted when those questions were de-tagged, for whatever reason. I don'...


10

The two terms are essentially about the same concept – materialisation of the result of a query. The differences are outlined in Jack's answer and I personally believe them to be inessential to warrant the split. However, I disagree with the current state of affairs too. An alternative to splitting the pair would be to switch the synonym, i.e. make indexed-...


10

This answer disagrees that major changes to the migration tag excerpt or wiki are required. Maybe the existing content could be tweaked slightly to emphasise that the tag is primarily for one-off or irregular data migrations (discussed below). It seems wrong (to take an example) to tag a question about moving data from one physical host or location to ...


10

Sort of. It is worth having sql-server-management-studio but it should be a synonym of ssms as management-studio currently is. Result: ssms would remain the display tag, but tag search etc. would match the longer forms. status-completed


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

Yes, crosstab should be a synonym of pivot and merged. Any product-specific differences are indicated by the product tag. Update A synonym has been created. crosstab has been removed from 9 questions. pivot has been added to 4 questions. Tag merge completed.


8

My gripe with sql is that query is an alias to it. So tagging questions about other query languages results in them being tagged sql which is incorrect. The query->sql synonym was removed in July 2018.


8

My suggestion: do not target specific people simply because you think they can answer your question (people do that to me and, while I'm happy to help wherever I can, I also appreciate the ability to pick and choose which questions I focus on). There are other ways to get attention for your questions, and really you should stop thinking of any single ...


8

The sql tag has now been burninated. It has also been blacklisted. (technically, marked intrinsic, so inbound migrations are not blocked; the tag is removed during migration). Thanks to everyone who participated in the discussion and clean-up effort.


7

No. Tags are used to categorize questions so that subject area experts can locate them easily. Adding a tag that describes the answer does not assist in this purpose. From the Stack Exchange FAQ: Why do we tag questions? How do I correctly tag my questions?


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

Edit: The following has been categorized as a "canonical answer". I accept this categorization, and withdraw it as a proposed tag wiki. It's unclear when a canonical answer is worth more than an answer that's tailored to the particular question that was asked. Subtype Table Design There are lots of cases in database design where it is useful to model ...


7

I'm not a fan of having tags per product (aside from the top level ones, of course), so sqlserver-listener is a non-starter for me. There does not appear to be any crucial difference between an Oracle Net Listener, and any other sort of Listener, so it seems unnecessary to create ag-listener, especially since listener only has 47 questions (21 in the past ...


7

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


7

These tags are gone, and cannot be recreated; they're marked "intrinsic" so as to allow inbound migrations, but cannot be used on questions here.


7

The general SQL Server tag is useful for people looking to answer questions about SQL Server in general. The specific version tag is useful for: answerers, so they know what features and syntax may or may not be used in their solution future readers, so they know whether answers there might be more likely to be relevant to their problem It may seem like ...


7

sql-standard seems to be more general. I suggest we make both ansi-sql-standard and iso-sql-standard synonyms to sql-standard. ANSI and ISO have both been associated with the standard and I've seen used both the terms "ANSI SQL" and "ISO SQL" (and "ANSI/ISO SQL"), and still being used. status-completed


6

Tag Synonym table-partitioning -> partitioning has been completed.


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