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

9
votes
1answer
39 views

Should [database-restore] be a synonym of [restore]?

The tag restore has 461 questions. The tag database-restore has 54 questions but no wiki or excerpt. Furthermore, database-restoring is synonymized into restore. I can't imagine any reason for ...
7
votes
5answers
90 views

2015 Moderator Election Q&A - Question Collection

In connection with the moderator elections, we will be holding a Q&A with the candidates. This will be an opportunity for members of the community to pose questions to the candidates on the topic ...
0
votes
0answers
21 views

2015 Community Moderator Election

The 2015 Community Moderator Election is now underway! Community moderator elections have three phases: Nomination phase Primary phase Election phase Most elections take between two and three ...
2
votes
2answers
58 views

Is it ok to ask which database fits your problem?

I'm looking at building a radio play style streaming music player. My biggest concern right now is figuring out which database paradigm will fit the problem of calculating the next song the best. ...
5
votes
1answer
142 views

Subjectively speaking, is my question salvageable?

I wrote this this question, 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
71 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
134 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
5answers
72 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
159 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
75 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
89 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
85 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
37 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
32 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
157 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
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
33 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
36 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
169 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
172 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
248 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
128 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
174 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
73 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
126 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
39 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
51 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
69 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
86 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
35 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
27 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
105 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
33 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
244 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
49 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
115 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
81 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
47 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
63 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
146 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 ...
21
votes
2answers
260 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 ...