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
2answers
36 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
47 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
26 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
17 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
57 views

Why are you rejecting this Edit - Changed

I seem to recall that the options for rejecting an edit included "To minor" or something similar. Just wondering about the reasoning behind taking that option off? Current options show as:
2
votes
1answer
26 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
230 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
39 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
230 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
100 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
91 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
66 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
51 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
131 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
230 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
128 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
64 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
74 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
81 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
276 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.
8
votes
4answers
120 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
45 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
177 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
160 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
99 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
137 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
154 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
134 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 ...
9
votes
2answers
262 views

2013 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 ...
5
votes
1answer
89 views

did I not provide a possible answer?

While admittedly so basic I nearly didn't post it, isn't this a legitmate answer to the asker's question? Oracle UPDATE single record with multiple WHERE conditions Just want to make sure I'm ...
10
votes
5answers
225 views

2013 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 ...
9
votes
1answer
113 views

Active participation during election

So, I've done it; I've nominated myself for dba.SE moderator. Unfortunately, I am shipping off to Alaska for SQL Cruise starting May 24th, and from what I understand the election runs through May ...
8
votes
0answers
65 views

2013 Community Moderator Election

The 2013 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 ...
6
votes
1answer
78 views

Should I ask here about an academic paper on indexing?

I'm researching bitmap indexes for an MSc assignment. A good early paper on the topic is "Bit Transposed Files" by Wong et al, published in 1985. I find the paper's description of Composite Encoding ...