Stack Exchange
log in   chat   discuss   faq   users   badges

Area 51 » Technology

definition commitment beta
141
followers

Database Administrators

Launched Q&A site for database professionals who wish to improve their database skills and learn from others in the community.

Announcements

21  
Overlap with StackOverflow. – KennyTM Jun 6 '10 at 19:01
20  
I've asked database questions on both Stack Overflow and Server Fault. Stack Overflow gets you quicker and better answers simply because more people hang out there. I suspect a strictly database site, would suffer the same way – cindi Jun 8 '10 at 17:22
9  
Like the idea. there's a lot with databases that isn't development or admin (eg modelling). I'll come up with some questions. – Gary Jun 18 '10 at 6:58
show 17 more announcements
no discussions yet create new discussion

76 Example Questions (10 closed)

active oldest votes
up vote 1 down vote
What is the difference between SQL Server 2005, 2008 and 2008 R2? Which should I chose for a new project? Which one is cheaper to use?
added by Jeff Sep 16 '10 at 19:06
link
up vote 1 down vote
Help! I'm trying to connect to MySQL with SQL Workbench and get: Your connection attempt failed. Connection using old authentication protocol refused.
added by Jeff Sep 16 '10 at 19:21
link
This is a problem I came up against when installing s/w for a new workstation. I ended up downloading the latest s/w from MySQL and had to revert to the older MySQL Query Browser to connect to this old MySQL db until it's upgraded. :D – Jeff Sep 16 '10 at 19:23
up vote 1 down vote
How do I modify a table by altering, adding, or dropping columns with a SQL statement?
added by CWCarlos, edited by WikiSpeedia hang-around Oct 4 '10 at 17:59
link
too simplistic? – pate Sep 30 '10 at 8:45
up vote 1 down vote
How to make foreign key relationship on physically distributed data? BUT ON SERVERS LINKED using SQL Server 2008 link server technology.
added by user20166, edited by WikiSpeedia hang-around Oct 4 '10 at 17:59
link
up vote 1 down vote
How do I write a connection string using a Trusted Connection and Prompt for a username and password?
added by CWCarlos Sep 20 '10 at 14:51
link
up vote 1 down vote
Oracle 11.2: Can it be installed on Windows without being an administrator?
added by Leigh Riffel, edited by WikiSpeedia hang-around Oct 4 '10 at 17:57
link
up vote 1 down vote
How do I interpret the output of EXPLAIN on my queries in MySQL? I.e. what are the things to look for, and how do I decide what indexes to add/remove?
added by nos Sep 24 '10 at 18:32
link
up vote 0 down vote
Which kind of database do I need to use for [Drupal] ? [closed]
added by rlb.usa Jun 10 '10 at 16:19
link

closed as off topic by Aim Kai, Pedro Lopes, Grant Palin, peeles, Tea Drinker Aug 2 '10 at 22:12

This question does not relate to the topic of the proposal.
It was closed as part of an automated migration of off-topic to close votes on September 29, 2011.

up vote 0 down vote
How do I find a SQL Server/Oracle/mySQL/Postgres user group near me [closed]
added by Gary Jun 22 '10 at 0:46
link

closed as off topic by Grant Palin, William, Blake, Tea Drinker, xenoterracide Aug 4 '10 at 20:39

This question does not relate to the topic of the proposal.
It was closed as part of an automated migration of off-topic to close votes on September 29, 2011.

1  
19th vote. ONE MORE OFF TOPIC VOTE NEEDED! – meder Oct 6 '10 at 6:30
@mader yeah, but it took over 3 months to get those 19 votes ... 'Can I write off MS SQL Server on my taxes' got 12 votes in less than a month. (so if there's anyone who's not voting for it, that's one of the over 20 votes on the top two, consider moving a vote) – Joe Oct 6 '10 at 17:00
up vote 0 down vote
I have a Java program where I need to run the same SQL statement repeatedly with different values. What is the most efficient way of doing this? [closed]
added by Dwayne King Jun 23 '10 at 2:43
link

closed as off topic by Aim Kai, Grant Palin, William, horsedrowner, chenshap Jul 15 '10 at 17:56

This question does not relate to the topic of the proposal.
It was closed as part of an automated migration of off-topic to close votes on September 29, 2011.

Belongs on StackOverflow. – horsedrowner Jul 14 '10 at 10:18
Does it? telling them how to write a prepared statement is no good here? or write a stored procedure? – xenoterracide Aug 4 '10 at 20:16
I would be tempted to say stackoverflow as well. Does it make a difference that Java is calling it? To me it sounds like the author wants a Java based answer not a DB based one. – Toby Aug 18 '10 at 22:24
up vote 0 down vote
What do I need to be aware of when converting a SQL Server DTS package to an SSIS package?
added by thursdaysgeek Jun 30 '10 at 22:13
link
While SSIS and DTS are part of MS SQL Server, my opinion is that these are a more specialized field and there are already useful sites that deal with SSIS and DTS. – Jeff Jul 20 '10 at 15:58
2  
Where? What are those sites? And, are they in the SU family? – thursdaysgeek Jul 20 '10 at 21:15
up vote 0 down vote
If I install SQL Server 2008, then a SQL service pack, will anything break if I install another SQL Server 2008 instance? [closed]
added by William Jul 8 '10 at 11:14
link

closed as off topic by Blake, peeles, CWCarlos, Jake Wharton, EJC Oct 6 '10 at 16:50

This question does not relate to the topic of the proposal.
It was closed as part of an automated migration of off-topic to close votes on September 29, 2011.

up vote 0 down vote
How do I use [ORM]? [closed]
added by xenoterracide Aug 4 '10 at 20:28
link

closed as off topic by edosoft, Leigh Riffel, Gary, colithium, leeand00 Sep 10 '10 at 2:50

This question does not relate to the topic of the proposal.
It was closed as part of an automated migration of off-topic to close votes on September 29, 2011.

up vote 0 down vote
MySQL Workbench Keeps Crashing with {Exception}, How to Fix?
added by colithium Aug 23 '10 at 4:02
link
up vote 0 down vote
How can I automatically log into a MySQL database as root using a Shell script? Our security policy says we can't keep a password in the script itself
added by Stefan Lasiewski Aug 31 '10 at 3:57
link
up vote 0 down vote
I have data stored in a legacy application. How can I access this with SQL?
added by leeand00 Sep 10 '10 at 2:52
link
(This is an off topic post!) – leeand00 Sep 10 '10 at 2:53
1  
I can see this being an off-topic post, but I can also see where people might try to answer it by asking additional questions such as what the legacy application was using, there might be some kind of OLE DB or ODBC connector/interface to it. Then again... if it was a 3rd party Accounts Payable program or something like that there might not be. – Jeff Sep 16 '10 at 19:32
@Jeff that was what I had in mind, was some sort of 3rd party proprietary software. – leeand00 Sep 16 '10 at 22:29
up vote 0 down vote
Can I write off MS SQL Server on my taxes? [closed]
added by leeand00 Sep 10 '10 at 2:54
link

closed as off topic by Stefan Lasiewski, Jeff, chilltemp, Stephanie Page, CanSpice Sep 20 '10 at 16:41

This question does not relate to the topic of the proposal.
It was closed as part of an automated migration of off-topic to close votes on September 29, 2011.

(This is an off topic question!) – leeand00 Sep 10 '10 at 2:54
up vote 0 down vote
How can I convince my Boss to actually use a database?
added by leeand00 Sep 10 '10 at 2:55
link
I believe this is an off topic question. – leeand00 Sep 10 '10 at 2:55
Asked another way, this might be a good question-- "We track inventory in several dozen spreadsheets. How can a RDBMS help me?" – Stefan Lasiewski Sep 10 '10 at 22:54
I wish it was half a dozen spreadsheets. At least you could access the data with something that way! – leeand00 Sep 11 '10 at 15:56
up vote 0 down vote
I'm new to SQL and databases. My work has a bunch of databases in Excel. Which is better, Excel or SQL Server?
added by Jeff, edited by WikiSpeedia hang-around Oct 4 '10 at 18:05
link
I thought about using Access instead of Excel for this question, but figured it would be better as an off-topic example if it used Excel. I've worked with people in the past that kept everything in Excel, event things that would have been better in Excel; so I figured it might be a realistic off-topic Q. :D – Jeff Sep 16 '10 at 19:26
up vote 0 down vote
In what kind of solutions does a columnar database work better than a standard relational row database?
added by BozoJoe Sep 17 '10 at 0:30
link
up vote 0 down vote
How can I limit the type of data that can go into a table?
added by CWCarlos Sep 20 '10 at 15:07
link
up vote 0 down vote
In [RDMS], what are the top 10 do's and don'ts that affect scalability?
added by ScottCher Sep 21 '10 at 20:36
link
up vote 0 down vote
In [RDMS], how do I detect when my tuned queries are about to hit their tipping point and become less efficient and how do I mitigate the transition?
added by ScottCher, edited by WikiSpeedia hang-around Oct 4 '10 at 17:58
link
up vote 0 down vote
Oracle 11.2: Does CONTINUE work like EXIT in a cursor FOR loop?
added by Leigh Riffel Sep 22 '10 at 20:17
link
up vote 0 down vote
Oracle: Is there a way to allow a proxy connection to use passed authentication in a public database link?
added by Leigh Riffel Sep 22 '10 at 20:18
link
up vote 0 down vote
Oracle: Can SQL Plan Baselines be deleted in Bulk?
added by Leigh Riffel Sep 22 '10 at 20:20
link
up vote 0 down vote
How do I best perform an incremental backup of a large (> 20 GB) MySQL 5.1 server?
added by nos, edited by WikiSpeedia hang-around Oct 4 '10 at 17:49
link
up vote 0 down vote
How do I set the default isolation level in SQL Server 2008?
added by nos, edited by WikiSpeedia hang-around Oct 4 '10 at 17:48
link
up vote 0 down vote
How do I resync to our original master mysql server after failing over to our slave and allowing writes?
added by Brad Mace Oct 6 '10 at 4:57
link
up vote -1 down vote
How do I connect to {Database} from {Programming Language}? [closed]
added by colithium Aug 23 '10 at 4:01
link

closed as off topic by Clint Miller, CanSpice, chilltemp, CWCarlos, Jake Wharton Sep 23 '10 at 12:19

This question does not relate to the topic of the proposal.
It was closed as part of an automated migration of off-topic to close votes on September 29, 2011.

This could go on forever, breaking it into either 1 DB or 1 language could make it answerable – BozoJoe Sep 17 '10 at 0:27
...Well of course. The idea is that a SPECIFIC question that followed this form could be asked. On topic or off? – colithium Sep 17 '10 at 2:15
up vote -1 down vote
What type of table are you using for fine-grained transactions in MySQL tables now that Oracle owns the rights to InnoDB tables?
added by leeand00 Sep 10 '10 at 2:49
link
up vote -2 down vote
What's the maximum reasonable size of a SQLite database?
added by Master Of Disaster Jun 7 '10 at 11:54
link
Reasonable for what application? I'd argue this is a bad question. – Good Person Jun 8 '10 at 13:48
Not specific enough. A question like this would require too much background to answer properly. – Dwayne King Jun 23 '10 at 2:45
up vote -3 down vote
I want to learn SQL. Which database should I install to start with ?
added by Gary Jun 22 '10 at 0:47
link
This seems subjective. – Anonymous Jul 8 '10 at 13:59
up vote -3 down vote
Why does [database] suck? [closed]
added by xenoterracide Jul 28 '10 at 16:53
link

closed as off topic by Greg Bray, Tea Drinker, edosoft, b.roth, Leigh Riffel Aug 17 '10 at 19:53

This question does not relate to the topic of the proposal.
It was closed as part of an automated migration of off-topic to close votes on September 29, 2011.

up vote -3 down vote
What is the best tool to develop a database?
added by Filipe Costa Sep 17 '10 at 8:34
link
1  
While this question isn't really off-topic, it'd be a good example of a "too vague" question. The best tool really depends on what you mean by "develop a database". – CanSpice Sep 20 '10 at 16:43
up vote -4 down vote
PostgreSQL - does it have a future? [closed]
added by William Jul 8 '10 at 11:15
link

closed as off topic by Joe, BenV, TGnat, horsedrowner, chenshap Jul 15 '10 at 17:55

This question does not relate to the topic of the proposal.
It was closed as part of an automated migration of off-topic to close votes on September 29, 2011.

I would be ok with this question if it were MySQL in reference to the recent forks and oracle buyout. But there's absolutely nothing to suggest that postgres is taking a downturn. – xenoterracide Jul 21 '10 at 7:57
I'm just not sure conjecture about the future of a database system has a place in this site - I can read about this kind of stuff in the trade mags... – ScottCher Sep 21 '10 at 20:29
prev 1 2

This site has

Launched!

This Stack Exchange site's beta was successful, so it launched 1 year ago.

proposed by

Aim Kai
8,792●3●22●78

2 years ago

edited by

Jeff Atwood♦ ♦ 27
305k●186●1103●1923

2 years ago

viewed

9,929 times

latest activity

2 years ago

followers

users also following

16.3% Personal Producti...
12.8% Code Review
12.1% Software Quality...
11.3% Project Management
11.3% only this proposal

followers active in

87.9% Stack Overflow
56.0% Super User
53.2% Server Fault
51.8% Programmers
51.1% Meta Stack Overflow
39.0% Web Applications

recent followers

added May 24 '11 at 8:24
Andrew Russell
2,532●10●39
added Apr 24 '11 at 18:38
ogerard
9,776●40●145
added Mar 31 '11 at 23:28
Michael McGowan
9,641●2●41●195
added Jan 2 '11 at 14:40
Avi
13.5k●1●31●64
added Dec 30 '10 at 0:43
mjcopple
1,651●9●39
added Dec 23 '10 at 4:29
Electric Automation
3,273●5●33●70
added Dec 22 '10 at 18:08
morganpdx
9,535●3●43●163
added Dec 21 '10 at 16:39
neural_ck
69●3
added Dec 20 '10 at 7:08
Eddie Awad
2,969●1●9●21
added Dec 17 '10 at 14:42
Ither
2,562●4●27●74
added Dec 17 '10 at 7:12
dan_waterworth
8,288●1●30●75
added Dec 16 '10 at 4:31
Jeremy M
794●3●8
added Dec 15 '10 at 6:35
Tianyi Cui
1,072●1●7●27
added Dec 14 '10 at 4:26
LittleBobbyTables
29.3k●16●69●196
added Dec 12 '10 at 8:14
Colin Pickard
24.2k●4●69●168
added Dec 10 '10 at 10:47
Denis Otkidach
11.3k●2●19●63
added Dec 10 '10 at 3:50
djatnieks
51●1
added Dec 9 '10 at 19:00
RegDwight ♦ 2
65.2k●29●222●439
added Dec 9 '10 at 11:29
Cary Chow
933●5●25
added Dec 9 '10 at 10:46
Michel de Ruiter
2,261●7●56
added Dec 8 '10 at 14:59
Dan McClain
10.1k●1●54●143
added Dec 8 '10 at 1:39
jamauss ♦ 1
3,010●13●40
added Dec 3 '10 at 14:19
Chris W. Rea ♦ 1
32.8k●24●168●478
added Dec 2 '10 at 6:49
Gaurav
4,377●21●57
added Nov 30 '10 at 5:37
Larry ♦ 1
10.4k●1●30●74
added Nov 29 '10 at 4:24
Ken Liu
7,773●4●39●92
added Nov 28 '10 at 21:59
Spredzy
3,486●4●27●68
added Nov 27 '10 at 12:35
Erik Kronberg
2,602●1●8●28
added Nov 26 '10 at 15:55
Bastian Spanneberg
1,141●7●28
added Nov 24 '10 at 3:17
glebm
5,550●2●16●40
added Nov 21 '10 at 3:47
Aragorn
2,001●2●25●56
added Nov 20 '10 at 13:22
Traroth
8,648●2●31●129
added Nov 20 '10 at 5:57
iKnowKungFoo
4,568●14●34
added Oct 31 '10 at 16:41
Martin Klinke
4,013●2●21●36
added Oct 21 '10 at 13:54
Guy
7,030●2●27●68
added Oct 19 '10 at 12:30
pate
6,486●3●32●135
added Oct 15 '10 at 11:04
Nils
1,689●1●9●38
added Oct 8 '10 at 2:04
Sathya ♦ 2
65.7k●31●206●555
added Oct 6 '10 at 22:03
marramgrass
1,367●5●14
added Oct 6 '10 at 16:43
EJC
1,255●2●14●46
feed icon proposal feed
faq | blog | legal | privacy policy | contact us | feedback always welcome
site design / logo © 2011 stack exchange, inc.; user contributions licensed under cc-wiki with attribution required
rev 2013.5.22.149