Area 51 » Technology

definition commitment beta
140
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

76 Example Questions (10 closed)

active oldest votes
up vote 2 down vote
I have a production MySQL database. How can I copy the data in this database to a standby database? We can't take it down or lock it for mysqldumps.
added by Stefan Lasiewski Aug 31 '10 at 3:45
link
An example of a beginner's quest into MySQL replication. – Stefan Lasiewski Aug 31 '10 at 3:45
up vote 2 down vote
I tried to connect to my MySQL server using `mysql -h localhost -u root -p P@SSword` but this didn't work. Why did MySQL not accept 'P@SSword'?
added by Stefan Lasiewski Aug 31 '10 at 3:54
link
up vote 2 down vote
Which is better (in SQL Server), select a.fld1, b.fld2 from a join b on a.id1 = b.id1 or select a.fld1, b.fld2 from a, b where a.id1 = b.id1?
added by thursdaysgeek, edited by WikiSpeedia hang-around Oct 4 '10 at 17:58
link
up vote 1 down vote
Where can I find informative resources for SQL Azure?
added by Aim Kai Jun 6 '10 at 16:01
link
up vote 1 down vote
Is there a free software addition to SQLite available for data-replication?
added by ralf.w., edited by WikiSpeedia hang-around Oct 4 '10 at 19:16
link
up vote 1 down vote
How can I see what the next available identity value is in [SQL Server]?
added by edosoft, edited by WikiSpeedia hang-around Oct 4 '10 at 19:15
link
up vote 1 down vote
Does Domain/Key Normal Form have an equivalent in the {hierarchical,network} model?
added by finnw Aug 9 '10 at 23:00
link
up vote 1 down vote
How can I implement common queries for a hierarchical tag schema?
added by colithium Aug 23 '10 at 4:03
link
up vote 1 down vote
I have a new project for a startup company and I'm trying to decide between SQL Server express and MySQL. Which one is better for a small web server?
added by Jeff Sep 16 '10 at 19:03
link
Thought about adding PostgreSQL too, but I ran out of room. I figured this is a pretty common question, although it would probably be a decision between MySQL and PostgreSQL from what I've heard from different web developers. – Jeff Sep 16 '10 at 19:25
up vote 1 down vote
We are using a 3rd party software that says it requires SQL Server 2005 Standard, would it be okay to use 2008 instead? Can I use developer edition?
added by Jeff Sep 16 '10 at 19:05
link
I came up with this one based on some products I've worked with at past employers... it always seemed that we had to have a dedicated SQL Server or Oracle box for a specific application, and it never seemed to be the latest version of either. – Jeff Sep 16 '10 at 19:30
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? – FreshCode 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
1 2 3