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

6
votes
1answer
187 views

someone votes down against my question - should I do something about it?

One of these days I have posted the following question: Unable to create a Filtered Index on a Computed Column which someone decided to downvote. I had a look at the question, and I cannot find ...
7
votes
2answers
103 views

Relational vs. RDBMS vs. Relational-Theory

The relational tag has a description that seems very similar to the rdbms tag, but it seems to be used often in lieu of the relational-theory tag.* Relational short description: Category of ...
5
votes
0answers
45 views

IBM i (as/400) clarifications [closed]

Can we make the tag ibm-midrange and iseries the alias? iSeries is a decade old, but autocorrect in the tag field suggests it.. Also, should there be a DB2-fo-IBM-i tag for issue that are specific to ...
13
votes
1answer
170 views

Privileges vs Permissions

I might be missing a fundamental difference between the two, but shouldn't the tag Privileges be a synonym of the tag Permissions? (Click either tag above to view their info/about page) ...
10
votes
1answer
106 views

Can I Ask About Networking Specifications Related To a Database Setup?

Background In a datacenter rack I want to dedicate 10Us for DB that an app connects to directly and another 10 for backup purposes. For security purposes, the IP addresses for those backup servers ...
-1
votes
4answers
141 views

Misunderstood question closed and locked

The question was about "why use the index for a SELECT *" and it turns out that the primary key is a clustered index, so reading from a covering index is faster. You lot locked onto "there's no order ...
9
votes
1answer
77 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 ...
17
votes
2answers
158 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
57 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
118 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 ...
29
votes
1answer
199 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 ...
23
votes
1answer
231 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
58 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 ...
15
votes
4answers
356 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
79 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 ...
8
votes
6answers
166 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
37 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 ...
4
votes
2answers
94 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. I'...
5
votes
1answer
150 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
79 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 ...
10
votes
2answers
154 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
88 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
170 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
85 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
102 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
90 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
46 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
33 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: http://dba....
17
votes
4answers
203 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
33 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
45 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
34 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
131 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 ~11,000....
2
votes
0answers
63 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 answer,...
1
vote
0answers
42 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
170 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
191 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
256 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
39 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 ...
16
votes
1answer
148 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 ...
10
votes
5answers
240 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
74 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 ...
10
votes
0answers
131 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
55 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
50 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
57 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
70 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
95 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 ...