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
61 views

is there a place to request feedback for analysis I've already done on a complex issue

I've had a complex issue involving strange wait types, VM ware, deadlocks,existing code and more. I've done in depth analysis and I think I've figured it out based on a ton of research. I'd like ...
14
votes
2answers
127 views

Which site is best for code reviews of queries?

Imagine a junior database developer / DBA that may not have an avenue to get their SQL code reviewed for best practices and such as they are learning the ropes. There is of course the Code Review ...
5
votes
1answer
52 views

Editing a question to add a tag for RDBMS after the question has an answer

In the short time that I've been a member of the community I've noticed that the OP sometimes doesn't tag their question with the RDBMS (go figure :)). Community members often ask for this ...
9
votes
1answer
83 views

Should DBA be the primary phpMyAdmin usage support channel?

The phpMyAdmin support page points to stackoverflow.com and serverfault.com as the sole (non-bug related) support mechanism: Getting support Effective September 1st, 2013, support for ...
26
votes
0answers
145 views

2015 Moderator Election Results

Database Administrators' fourth moderator election has come to a close, the votes have been tallied, and the new moderator is: He'll be joining the existing crew shortly — please thank him for ...
22
votes
1answer
202 views

Why is dba.stackexchange so…welcoming?

Perhaps this is but my first impression of DBA, but it's surely a pleasant one. I recently asked a fairly basic question about Postgres's indexing abilities. I was greeted with AMAZINGLY cordial and ...
1
vote
1answer
50 views

Why is RDBMS Type not a required field on this exchange?

I haven't been on this stack very long but there seems to be a consistent issue of people not listing their RDBMS platform. Makes answers difficult or irrelevant if submitted. Seems like we need some ...
14
votes
4answers
326 views

2015 Moderator Election Q&A - Questionnaire

In connection with the moderator elections, we are holding a Q&A thread for the candidates. Questions collected from an earlier thread have been compiled into this one, which shall now serve as ...
11
votes
1answer
75 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
6answers
157 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 ...
1
vote
0answers
32 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 ...
3
votes
2answers
85 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
144 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
74 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
144 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
78 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
166 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 ...
6
votes
1answer
82 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
2answers
96 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
87 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
43 views

Should each RDBMS tag have a version number? [duplicate]

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
166 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
30 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
121 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
60 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
174 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
250 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
36 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
129 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 ...
9
votes
5answers
215 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
46 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
38 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
28 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
106 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:
4
votes
1answer
34 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
246 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 ...