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

11
votes
1answer
222 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
94 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
87 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
63 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
39 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
42 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
130 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 ...
16
votes
2answers
229 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
124 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
60 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
73 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
78 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
274 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
58 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
117 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
176 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
159 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
136 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
178 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 ...
6
votes
1answer
65 views

Are “Help me with this query” questions on topic?

Are "Help me with this query" questions on topic here or are they 'too localized'? I have a table, with indexes but the explain seems to indicate that the indexes are not used and I'd like some ...
0
votes
1answer
64 views

Network Databases - 2

I fail to see why my previous question was closed. I merely asked whether or not there were any free/open source network (IDMS-type) databases, with the implication that, if there were, an indication ...
1
vote
0answers
38 views

Migrate SO questions here and close as duplicate or close at SO?

How to permanently delete a row in oracle forever This question prior to being migrated to dba.se already had a comment that it was previously answered on dba.se, with a link. However, the close ...
6
votes
1answer
99 views

Should database theory questions be posted here, in cstheory or in cs?

As per title, it doesn't seem to be clear. As an aside, maybe for similar situations you should add a feature to allow to add a link to the question on the questions pane of the closely related ...
13
votes
1answer
146 views

Can we change the comment-flag system on The Heap chatroom?

Yesterday (April 1st, April Fools Day notwithstanding) we had some high-ranking members of DBA.SE banned from chat by moderators/10k users from other sites that did not take an appropriate amount of ...
2
votes
1answer
26 views

Is this the place to ask Memcached performance questions?

I'm attempting to diagnose an issue with my Memcached performance, however there is no tag for "memcache"! Is there a better stackexchange than dba.stackexchange.com to ask my memcache questions?
5
votes
3answers
85 views

Should there be a data-modeling tag?

I looked at the tags, and noticed that there is no tag for data modeling. Before I try to add one, (assuming that I can) I'd like to find out whether the community has already thought about such a ...
24
votes
4answers
218 views

Can We / Should We Strongly Encourage Users to Specify RDBMS on the “Ask” page?

More than most other sites, the majority of our questions require a specific piece of information: What RDBMS and what version is the asker using? If it's possible, would it be a benefit to add ...