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

1
vote
1answer
55 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 ...
8
votes
0answers
103 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 ...
1
vote
0answers
33 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 ...
3
votes
1answer
45 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. ...
0
votes
0answers
39 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 ...
2
votes
1answer
40 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 ...
6
votes
2answers
59 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 ...
3
votes
2answers
76 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 ...
5
votes
1answer
29 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 ...
1
vote
1answer
19 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 ...
4
votes
1answer
89 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:
2
votes
1answer
28 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 ...
8
votes
1answer
238 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 ...
2
votes
2answers
42 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 ...
11
votes
1answer
241 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 ...
16
votes
0answers
101 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 ...
8
votes
2answers
96 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
68 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 ...
2
votes
1answer
40 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 ...
2
votes
0answers
55 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 ...
3
votes
3answers
139 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 ...
17
votes
2answers
235 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 ...
10
votes
2answers
130 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 ...
-2
votes
1answer
78 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 ...
1
vote
0answers
28 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. ...
2
votes
3answers
77 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 ...
5
votes
1answer
84 views

Are Couchbase questions on topic?

I noticed that there was no tag for Couchbase and only a small number of questions mentioning it. So are Couchbase questions on-topic for this site - dba.SE (it which case it'd be lovely to get a ...
11
votes
1answer
139 views

Petition to reopen a CDC question

I am currently investigating whether to use the SQL Server feature Change Data Capture (CDC) for a data framework I am developing. During my research I found much on how to use CDC, but not as much ...
1
vote
1answer
45 views

Can I ask conversational questions? (Training)

I would like to ask the following question but is DBA Stackexchange the right place? Is there any place on Stackexchange for it? Please do answer the questions above, if you would, not the question ...
10
votes
1answer
82 views

Delete tag sqlsql-server-2012

I hope I'm proposing this in the correct way. sqlsql-server-2012 seems to be a spelling mistake of sql-server-2012. There were 2 questions with this tag, for which edits to change the tag from ...
9
votes
7answers
283 views

Shall we add a new 'off-topic' reason for questions that are 'too basic'?

We get questions from time to time like this one or the odd 'how do I join two tables' SQL question, which fall short of our 'expert-level'. Some are best migrated to SO, but for the rest, would it ...
3
votes
5answers
211 views

Image choice for caption competitions

I recently deleted a competition initiated by a user on this site. I have extremely mixed feelings since: We love when users show initiative on our sites. In this case, there was a major award and ...
6
votes
2answers
59 views

Synonym trigger and triggers

trigger - 29 questions triggers - 202 questions The singular tag name seems redundant. I'd suggest that triggers be kept, and the other be synonym'd.
10
votes
4answers
136 views

Community Promotion Ads - 2014

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

How to ask “Why did the optimizer choose this query plan?”

I implemented a function to suggest movies from the example PostgreSQL database given in Seven Databases in Seven weeks. The first attempt was correct but slow. The function could take more than ...
14
votes
3answers
190 views

Shall we add a new 'off-topic' reason for questions that really need professional support?

We get questions like this where it is immediately obvious that the OP has a much bigger issue than they realise, and they need a consultant or vendor support, much hand holding and hands-on access to ...
3
votes
1answer
44 views

Should questions be marked with contraindicated tags?

Should a question be marked with a tag such as database-mirroring if the OP identifies that mirroring doesn't apply? For reference, see this question which has 3 tags about tech the OP has identified ...
5
votes
1answer
51 views

are Code Reviews for Functions/sprocs/etc. acceptable questions here?

I don't see very many review questions for SQL on CodeReview.StackExchange.com and was wondering if I should be posting them here instead? I haven't posted any yet, but would like to know if that is ...
4
votes
1answer
73 views

What is Association Bonus?

Can anyone help me regarding association bonus? What is this association bonus anyway?
11
votes
2answers
84 views

Should old questions that have no answers and are “too localized” or “too broad” be closed?

For reference, look at this question: Invalid Object SQL Server 2005 Express The question appears to be abandoned, and offers no real help to future visitors. Should it be closed, or do we care?
5
votes
2answers
161 views

Is it appropriate to ask for database design review here?

There's codereview stackexchange to ask to get.. well your code reviewed :D. Unfortunately, there doesn't seem to be anything equivalent for database reviewing. Would it be appropriate to put ...
10
votes
2answers
106 views

On link-only or link-mostly answers

As a community we can decide how we should handle link-only or link-mostly answers, possibly in a different way than SO does (and that is a constantly / moving / target / anyway). I'm not even clear ...
9
votes
1answer
138 views

Dealing with SQLServerPedia link-rot

Last week I posted a question on meta.SO about SQLServerPedia link rot. Essentially, all of the links we have here on dba.SE that point there are dead - they either go to a 404 page or the front page ...
4
votes
1answer
122 views

Should there be an entity-relationship tag?

In the last few months, more and more database-design questions have been migrated over here to dba. There is an entity-relationship tag over in SO. It's widely used, and I think usefully so. ...
6
votes
2answers
143 views

How do I handle multiple correct, yet distinctly different answers?

I recently asked a question [1] that has multiple correct answers, each with their own pros and cons. Nick's answer uses recursive CTE's to provide the solution as efficiently as possible, but ...
14
votes
1answer
96 views

A request for elaboration when migrating SO questions

As is discussed regularly in the heap, there seems to be a steady decline in the overall quality of questions on StackOverflow. I am nervous that this symptom will bleed into our site, and to prevent ...
14
votes
1answer
155 views

What should our list of off-topic close reasons be?

Close reasons are changing, as well as the sub-reasons for off-topic. We should probably try to avoid falling behind. This post borrows quite heavily from this post on meta.robotics (which borrowed ...
6
votes
1answer
135 views

Newbie Questions

Over the years (2 years, actually), I have seen many posts where the asker introduces himself/herself as a newbie. Some questions are blantantly easily, others more profound. In either case, here is ...
13
votes
0answers
152 views

Badge for elected Moderators

I think an elected Moderator should have a badge for getting elected. That way past moderators will be esteemed for their contribution. Come to think of it - if there are badges for ...
19
votes
0answers
179 views

2013 Moderator Election Results

Database Administrators' third 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 ...