The question you're asking is designed to solicit opinions or best-practices on a particular topic, with the goal of reaching community consensus.

learn more… | top users | synonyms

3
votes
0answers
36 views

Subjectively speaking, is my question salvageable?

I wrote this this question yesterday, thinking it might be a good general question to get started. I ended up revising it massively with some good comments. I read the background on what makes a good ...
1
vote
1answer
41 views

Recommendation: Beginner needs to Regularly Post SQL Code for Troubleshooting. Where to?

I am doing an internship that requires me to learn how to use SQL within SAS to run queries. Since I have little experience, I will need to frequently post code in order to check it for efficiency as ...
8
votes
2answers
90 views

Can we be allowed to choose a suitable forum if DBA.SE is not suitable?

I recently voted to close this post. I wanted to specify that it was off-topic and that it belonged on another StackExchange site (in this case, Information Security). However, I was only allowed the ...
4
votes
5answers
55 views

Should the optimization tag be re-purposed away from “query optimization” and towards “general” system-level optimization?

optimization has this in the tag excerpt: In the context of a database, optimisation refers to the process of the query optimiser selecting an efficient physical execution plan. However, there ...
5
votes
1answer
130 views

why is my question closed as unclear what you're asking?

I think my question is pretty clear I would like to Merge customer_id from table user to table cust where customers_firstname AND customers_name match And I attached two images In fact it was ...
4
votes
1answer
60 views

gut feelings in questions that may not have a clear answer

I just asked this question which may or may not have a clear answer, so at the end, I asked for "gut feelings" (or code smells, if that term translates to the database crowd), and then asked users to ...
10
votes
1answer
81 views

Questions with no “marked” answer used to close others as duplicate

I understand the rules around what constitutes a duplicate question. My question is in regard to use of marking a specific question as duplicate, and the question selected as duplicate does not have ...
5
votes
1answer
75 views

What should I do about an old question that I'm not interested in finding an answer for?

I posted the following question about a year ago: http://dba.stackexchange.com/questions/65818/db2-query-error-sql0204n-even-with-the-schema-defined It went unanswered and I have since stopped using ...
3
votes
0answers
27 views

Should each RDBMS tag have a version number?

We have RDBMS tags such as mysql and sql-server but should we only allow tags like this with the version appended? sql-server-2000 mysql-5.6 The reason I bring this up is the features and behavior of ...
3
votes
0answers
29 views

Can suggested tag synonyms be added to the “Review” queue?

It would be great if the suggested tag synonyms page: http://dba.stackexchange.com/tags/synonyms?filter=suggested&tab=newest Where displayed in the standard "Review" queue: ...
13
votes
4answers
148 views

Is the [sql] tag useful for DBA.SE?

Both DBA.SE and Stack Overflow suffer from a similar problem, when users post sql related questions there is a tendency to solely tag the question with sql but exclude the RDBMS. This is great if ...
-1
votes
1answer
27 views

May I ask a difference between a database specific term and a technology generic term?

I have a persistent doubt about the difference of data warehousing and data archiving, but I fear being downvoted to hell by posting this in DBA. Is it ok, or is it off-topic?
2
votes
0answers
34 views

Can Model-specific questions be asked here?

I'm working on a personal project and having a difficult time working out the model to develop the database for it. I was going to just ask my question here when I realized that it might considered ...
3
votes
1answer
32 views

Is this question a better fit for SO?

I always struggle on deciding if a question is a good fit for here or for it would be better in SO. Is this question a good fit for SE.DA or It would be better if post it in SO? After reading the ...
13
votes
1answer
120 views

Do Solr configuration questions belong on DBA?

Are questions related to configuring Apache Solr on topic at DBA? By sheer number of questions, I'm uncertain. DBA has 1 question tagged for solr, Server Fault has ~150, and Stack Overflow has ...
2
votes
0answers
56 views

Why is this question off-topic?

Recently, a question that I answered was voted off-topic. I would like a clarification why exactly is this off-topic? I think the question was relevant to this site. It might not have an exact ...
1
vote
0answers
34 views

Questions about how to choose proper hardware

I asked this question here. Which is put on hold for asking for a product. But really (as seen in the last line), I'm asking how to choose. How can I edit this question to make it acceptable?
12
votes
0answers
166 views

Site Design Updates

As you can see, the DBA community site got a slight design update today. We have moved the site's CSS to a newly refactored LESS system, so it's easier for us to fix SE network CSS bugs globally in ...
5
votes
2answers
164 views

I have the answer, but what was the question?

I have a little solution that I want to share with today's DBAs but I'm really uncertain that the problem it solves is still of interest to anyone. for some reason, the "answer your own question" ...
10
votes
2answers
246 views

Why was this clear question downvoted?

How to clone a user in SQL Server 2008 R2? I don't notice any votes to close it, and it has a helpful answer with +7 but the question is sitting at -4. I couldn't find any similar questions with a ...
1
vote
1answer
35 views

Is this question really a duplicate?

I asked this question How to use insert and select simultaneously? This question clearly asks for getting the id value after a row is inserted and it was closed for duplicate of this question How to ...
15
votes
1answer
126 views

I propose we add a Vote-to-Close reason to handle licensing questions

I would propose the following wording, or some variation there-of: This question appears to be off-topic because it is about licensing. Questions on licensing should be referred to the vendor, ...
6
votes
7answers
151 views

Experimenting with top user ticker overlay feeds in The Heap

I made a feature-request on M.SE which met with a mixed reception - guarded interest plus virulent opposition. Basically I was suggesting having an overlay ticker-feed of activity on the main site of ...
7
votes
4answers
173 views

Community Promotion Ads - 2015

The dawn of a new year, 2015, now approaches, or has already approached, either way it means that it is now time to reset our Community Promotion Ads! What are Community Promotion Ads? Community ...
2
votes
1answer
72 views

Closed as Too Localized

The Too Localized reason for closing a question seems to general. I'm still not sure why my question was closed: Database Implementations of ORDER BY in a Subquery Too localized - this could be ...
9
votes
0answers
122 views

Improving my answer after it's been accepted

If my answer is accepted and then someone else adds an answer that isn't as good but has a few points that I didn't have should I add those points to my answer? Feels like I would be stealing their ...
3
votes
0answers
38 views

Question is on hold

My question was put on hold because it is unclear. I thought it could happen because I have little familiarity with the subject, probably use the wrong terminology etc. Could you tell me what is ...
4
votes
1answer
54 views

I've asked some questions on here, figured it out and I want to share my data. Where?

I see quite often (maybe because I am searching for it) people recommending Geonames for postal code data, etc. I've taken data from Geonames and a few other places and spent some time cleaning it up. ...
1
vote
0answers
45 views

There went something wrong when identifying duplicates

The question Need Query for th problem in oracle was identified as duplicate of Need query for the below problem. If one reads the title one can be almost sure it must be the same query but I am not ...
3
votes
1answer
49 views

How should long queries relevant to a question be handled?

Where a question concerns query performance, how should the query be included in the question if it is very long (tens or even hundred of lines)? On SO, code posted in a question should be whittled ...
7
votes
2answers
68 views

On topic-ness for questions covering publisher documents

In this question, What is the minimum required compatibility level to use parallel SELECT INTO in SQL Server 2014? the poster contends that the question is relevant because it is I'm ...
5
votes
2answers
85 views

Is question about improving database design on topic?

I was working on a creation of Informational System and had to create database that held large amount of data, with GUI that was responsible for edition/insertion/report building... Database was ...
6
votes
1answer
34 views

Synonym: table-partitioning -> partitioning

table-partitioning - 38 questions partitioning - 247 questions. Most questions tagged table-partitioning are also tagged partitioning. The current wiki excerpt for partitioning is: "Splitting a ...
2
votes
1answer
26 views

Duplicate caused by Migration

A question was asked both here and at SO. The one at SO got a response, then got migrated here. Now there are two duplicates here, with answers on both of them. I deleted my answer from one of ...
5
votes
1answer
103 views

Why are you rejecting this Edit - Changed

I seem to recall that the options for rejecting an edit included "Too minor" or something similar. Just wondering about the reasoning behind taking that option off? Current options show as:
3
votes
1answer
32 views

Is there (or could there be) a mechanism to watch threads/questions?

Is there a mechanism to watch threads (and I don't just mean those that one has started)? For example, I might find a thread in which I'd be interested but don't know enough about to contribute? In ...
9
votes
1answer
243 views

handling of an unanswered question

The question Find active values of SQLNET.ORA parameters on server received 0 upvotes and the OP issued a bounty of value 50 but no one answered. Therefore the OP posted an answer where he stated that ...
3
votes
2answers
48 views

Why recycle posts for people who aren't interested?

This post reappeared on dba.stackexchange a few minutes ago (01:20 UTC), but the person who asked the original question hasn't visited the site for almost 9 months. Why should questions by people ...
13
votes
1answer
254 views

MSSQL vs SQL Server

I just had one of my questions edited, changing instances of MSSQL to SQL Server in the text. I don't have a problem with this, I just wanted to check what the consensus was on the use of 'MSSQL' to ...
19
votes
0answers
108 views

Remove tag [tag:access] and blacklist it

The tag access has no description and I've seen it used in at least three different contexts: Microsoft Access, but there's already a tag ms-access for this. privileges a user has on an object, but ...
9
votes
2answers
107 views

Remove tag alias indexed-view for materialized-view

The tag indexed-view is an alias for materialized-view. Which means when posting a question regarding an Oracle materialized view this will be tagged with a tag that refers to a SQL Server technology. ...
-7
votes
2answers
77 views

New Tag for SQL Server Installation

I cannot find specific tag ' SQL Server installation' however there is a tag 'Installation'. If we could create this tag it would be good for users to use this tag to specifically tell this is ...
3
votes
1answer
42 views

Encourage new/all posters to give DDL and DML?

When asking questions, shouldn't we encourage new (indeed all) posters to give DDL and DML rather than table descriptions and rows of data? I'll use a trivial example from MySQL. mysql> create ...
3
votes
0answers
60 views

I have a “big” database, what RDBMS/design should I use?

There are several instances of this type of question lurking around. The answers are invariably opinionated, irrelevant, and in some cases intentionally misrepresentative or just plain wrong. Should ...
4
votes
3answers
143 views

New tag called “subtypes”?

Note: the "subtypes" tag has been created. Now let's see if it gets used. Revised proposal at end. I am proposing a tag to be named "subtype-table-design". This would collect questions relating to ...
20
votes
2answers
255 views

My reviewing of questions is declared “blatantly bad”; why, and how can I improve?

I've started seeing this strongly worded message recently when clicking the Review link: You have approved numerous edits or first posts that were blatantly bad and needed editing or should not ...
11
votes
2answers
135 views

Is DBA the best place for questions related to SQL/DBA tools?

Are questions about configuring or using SQL/DBA tool, such as SQL Studio, SQL Developer, TOAD, or phpMyAdmin, best posted on DBA? If not, what is the best SE site for such? The kind of question I ...
-1
votes
1answer
106 views

(SQL) Titles in caps lock

I am aware of "Whether we should be CAP COPs", however would like to ask for a special exception regarding titles. The reason for this is that for example right now on the entire SE network users see ...
2
votes
0answers
30 views

Should we allow, even encourage, “feature comparison style” questions?

The more specific the piece of technology one uses, the more difficult it is for someone without extensive knowledge of that piece of technology to make informed decisions as to how best to use it. ...
3
votes
3answers
82 views

Error occurred while submitting your question?

I have been trying to post a question in the Database Administrators Site for a while and each time I get the error: An error occurred submitting the question I am using IE10. Are there any ...