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 ...
12
votes
2answers
239 views

Why are database developers' Q&A migrated to DBAs site

The following link is an example: How SQL Server handles concurrent requests? Why was it migrated to DBAs site? I think that at this time such questions get more exposure on stackoverflow. As such, ...
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 ...
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 ...
22
votes
4answers
588 views

Should basic SQL questions be allowed?

I’m going to buck the pervasive mentality here and ask the question:    Why shouldn’t dba.stackexchange.com include basic SQL questions? Previous related discussions: How do we ...
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
112 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 ...
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 ...
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 ...
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 ...
20
votes
1answer
599 views

Canonical Answers

After discovering the pot of gold that is ServerFault's What are the canonical answers we've discovered over the years?, I'm inclined to think dba.se could do with the same. If agreeable to ...
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
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. ...
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?
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 ...
6
votes
1answer
112 views

Are questions about database design considered appropriate? [duplicate]

Would you consider questions about database design as appropriate for this website?
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 ...
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 ...
5
votes
5answers
142 views

What image does our new theme need for the captcha page?

What image does our new theme need for the captcha page? Pretty simple. Be creative people!
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 ...
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 ...
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 ...
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 ...
8
votes
32answers
355 views

Tag Cleanup - Vote for the following proposed tag changes

There are several proposed tags changes lingering about here on meta. I thought I'd capture them all here, each one as a separate answer, and let people vote on them. Awaiting Review make ...
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 ...
3
votes
7answers
121 views

Synonyms and Redundant Tags

Post synonyms and redundant tags here (one tag set per answer) for us to ponder and potentially edit out of existence.
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 ...
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 ...
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?
10
votes
2answers
190 views

How do we define a question as being “too basic”? Where do we draw the line?

It has been suggested that we close 'true beginner questions' as off-topic on this site. Where do we draw the line? For example, should this question be closed (I've voted to close it as off-topic, ...
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 ...
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 ...
14
votes
2answers
113 views

What about Business Intelligence?

I was wondering if Business Intelligence has its lace on this website ? In Business Intelligence we can see 3/4 domain that are parts of Database Expert : ETL Datawarehousing Data Modeling ...
18
votes
1answer
179 views

How do I include tables with Ascii art lines in my answer?

Some answers on the site like this one and this one include tables drawn with ascii art. Is this done by hand or is there a tool I can use to help me?
7
votes
2answers
130 views

Are questions about “no-SQL” databases OK?

Is it appropriate to ask questions about things like Redis (a data-structure server)?