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

4
votes
1answer
69 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 ...
4
votes
5answers
58 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 ...
1
vote
1answer
49 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 ...
9
votes
2answers
117 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 ...
5
votes
1answer
145 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
66 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
83 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
78 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 ...
13
votes
4answers
150 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 ...
12
votes
4answers
282 views

Sometimes, an answer is just plain wrong. What to do?

Why "Begin Transaction" before "Insert Query" locks the entire table? The question above contains outright, no two ways about it, plain old factually incorrect answers. I've ...
3
votes
0answers
32 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
30 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: ...
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 ...
-1
votes
1answer
28 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 ...
5
votes
2answers
165 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" ...
1
vote
0answers
35 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 ...
-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 ...
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 ...
26
votes
4answers
437 views

Are licensing questions within our scope?

I noticed Server Fault preemptively posted a dummy question explaining that they don't give licensing advice, as you really need to figure out licensing with the company granting the license. They use ...
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 ...
8
votes
4answers
147 views

What Constitutes Proper Editing of Questions and Answers?

Many times I look over some questions and answers and see the following scenarios: Places where spelling, grammar, punctuation, syntax, and format could be improved. Tags that are synonyms only. ...
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, ...
11
votes
4answers
153 views

Community Promotion Ads - 2014 [duplicate]

It's the time of the year again, namely it is December 2013, and so we shall now refresh our Community Promotion Ads for the new year. What are Community Promotion Ads? Community Promotion Ads are ...
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 ...
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:
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 ...
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 ...
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 ...
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. ...
3
votes
1answer
47 views

Question locking prevented answering

I answered this question about 10 minutes after it was posted (I remember seeing that it had been posted 8 minutes ago when I loaded it the first time). But my post was rejected because it had been ...
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 ...