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

10
votes
1answer
136 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
40 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 ...
8
votes
1answer
67 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 ...
8
votes
7answers
249 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
210 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
56 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
113 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
44 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
156 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
49 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
72 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
155 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
94 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
127 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 ...
13
votes
1answer
95 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
148 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
151 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
177 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
259 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
219 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
63 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
144 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
84 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 ...
23
votes
4answers
208 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 ...
10
votes
2answers
97 views

Are questions about implementation details of a database on topic?

Specific question on Stack Overflow: http://stackoverflow.com/questions/15468735/overview-of-how-mongodb-uses-its-various-threads In short, the OP is asking about what MongoDB uses it's threads for ...
1
vote
2answers
36 views

Migration makes tags orphaned references

A question, "How to Model Inheritance of Two Tables MYSQL" was migrated to this forum from Stackoverflow. Unfortunately, my answer to that question contained references to three tags that do not ...
27
votes
3answers
234 views

Whether we should be CAP COPs

A certain user has suggested a boatload of edits recently. The changes have been either largely or completely revolving around the upper-casing of Transact-SQL keywords. For example, a post that ...
3
votes
1answer
188 views

UPSERT synonym for MERGE?

I created a tag upsert (7x) today and wrote a somewhat useful (I hope) tag wiki. Later I found that there is already a tag merge (15x, no wiki). Would you consider the two synonymous? I can't mark ...
2
votes
1answer
63 views

It's the 14th of January. I still see sleighs

It's the 14th of January. I still see sleighs when people depart from chat. Christmas is over. When is it due to stop?
11
votes
1answer
249 views

Regarding the author's right to edit his own question

How do I add minutes to a time data type? This question has spontaneously devolved into an edit war. The author feels slighted. Here is his "closing volley" and then my ruling as a moderator ...
3
votes
1answer
41 views

Should this question have OS/Database tags?

It seems like the question On a dedicated database server, how much memory to reserve for the OS? should be tagged for a particular OS and database. How can the "Best" answer bubble to the top unless ...
5
votes
1answer
61 views

Post Deleted Answer?

The question below has an answer that was down-voted and then deleted by the owner. I was going to post something similar to the deleted answer. Would it be permissible to copy the deleted answer ...
18
votes
22answers
676 views

DBA.SE Xmas caption competition - 'tis the season to be jolly

DBA.SE Christmas caption competition In the spirit of the festive season, hats and all such matters, we proudly present the DBA.SE caption competition. The rules are simple: Answer this meta ...
2
votes
0answers
159 views

So what's with the hats thing?

you may have noticed some of our users now have hats around the site, and it might almost be annoying, but we assure you they're all in good fun, and intended to increase site participation! Here's ...
9
votes
3answers
135 views

Does My Answer Sound Like Product Endorsement?

I just posted an answer to a physical data security question : How to properly secure MySQL database? As I stated in the question, I normally don't endorse products. Since I posted an answer based on ...
8
votes
4answers
272 views

Community Promotion Ads - 2013 [duplicate]

As it is December 2012, we are now going to reset our Community Promotion Ads for the new year. Funny timing, this is exactly 400 posts later. What are Community Promotion Ads? Community Promotion ...
3
votes
2answers
45 views

Replacing an answer vs. updating an answer

I have answered a question, and based on feedback from the OP, most of my answer needs to be replaced/updated with the revised answer. My question: Should I append the new answer to the existing ...