Stack Exchange
log in sign up chat discuss faq users badges

Area 51 » Technology

definition commitment beta
142
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 newest votes
up vote 24 down vote
What are database triggers? What are the advantages/disadvantages and when is the right time to use them?
added by Dwayne King Jun 23 '10 at 2:55
link
q. should possibly be splitted (or just remove "What are triggers") – ralf.w. Jul 5 '10 at 13:16
up vote 22 down vote
What is the difference between a clustered and non-clustered index, and when should I use each?
added by thursdaysgeek Jun 30 '10 at 22:17
link
up vote 21 down vote
What's the difference between a LEFT OUTER JOIN and a RIGHT OUTER JOIN
added by Dwayne King Jun 23 '10 at 2:52
link
up vote 20 down vote
How do I "move" a [MS SQL] database from one server to another?
added by rlb.usa Jun 10 '10 at 16:19
link
what does server mean? physical server or database server? what does database mean? database server or files? – Stephanie Page Sep 16 '10 at 21:34
up vote 20 down vote
How do I re-write an Oracle style outer join, with (+), to a 'normal' outer join.
added by Gary Jun 22 '10 at 0:46
link
up vote 17 down vote
How do I debug a stored procedure in [database]?
added by thursdaysgeek Jun 30 '10 at 22:20
link
up vote 15 down vote
How do I secure [database]?
added by xenoterracide Aug 4 '10 at 20:07
link
up vote 10 down vote
Why are database features being ignored, and instead reinvented in the middle tier?
added by ObiWanKenobi Jul 15 '10 at 8:13
link
This is just subjective and argumentive – Mark Sep 16 '10 at 19:00
Yes, there is no right or wrong answer and even if you know AN answer, how would that help you. Please don't contrive a bizarre cascade of circumstance that only Dirk Gently can appreciate and follow. – Stephanie Page Sep 16 '10 at 21:33
up vote 8 down vote
How can I convert a [MS SQL bit type] to a [MySQL compatable type]?
added by rlb.usa Jun 10 '10 at 16:18
link
up vote 7 down vote
Are there any tools to convert my [MS SQL database] to a [MySQL database] ?
added by rlb.usa Jun 24 '10 at 23:31
link
up vote 7 down vote
I need to add an index to a 15 GB table. How long will it take and will the users notice?
added by William, edited by WikiSpeedia hang-around Oct 4 '10 at 19:17
link
up vote 7 down vote
I've recently had to start using [database] when I'm used to using [other database]. What sort of 'gotchas' should I be aware of?
added by Joe Jul 9 '10 at 11:14
link
eg, [really fast query] in [database1] is horribly inefficient in [database2] and should be rewritten as [...]. Or features that you've come to expect that you'll have to code around. – Joe Jul 9 '10 at 12:22
up vote 7 down vote
How can I represent a multi-hierarchical {taxonomy,thesaurus} in a {relational,NoSQL} database?
added by Joe Jul 9 '10 at 11:17
link
up vote 6 down vote
Based on the following execution plan from SQL Server 2005, can you please recommend any change to my query to improve performance
added by Waleed Al-Balooshi Jun 8 '10 at 16:20
link
up vote 6 down vote
When is it legitimate to break normalization?
added by mickeyf Aug 19 '10 at 21:23
link
up vote 5 down vote
How can I log all the connections to my SQL Server 2005 database that access a specific list of views?
added by William Jul 8 '10 at 11:09
link
up vote 5 down vote
Client needs a system where we can track drivers to deliveries. Should I have one table, or have two and join them?
added by Steven Lefevre Jul 8 '10 at 13:58
link
This is a design/modeling question. – Steven Lefevre Jul 8 '10 at 13:58
up vote 5 down vote
I have [problem description]. Should I use a relational database or a {heirarchical,network,nosql,flatfile} database ?
added by Joe Jul 9 '10 at 11:03
link
up vote 4 down vote
I've installed Oracle's free 10G XE version, and can't get to the admin page at http://127.0.0.1:8080/apex. What's wrong ?
added by Gary Jun 22 '10 at 0:39
link
up vote 4 down vote
What is the best file based (xcopy deployed) database for integration in .Net - apps ?
added by ralf.w. Jun 24 '10 at 6:31
link
up vote 3 down vote
Which T-SQL language constructs tend to be very expensive in query plans?
added by Jim G. Jun 26 '10 at 13:01
link
up vote 3 down vote
MySQL Backup Strategies, what are the best options available on projects that require a lot of backing up?
added by Toby, edited by WikiSpeedia hang-around Oct 4 '10 at 19:13
link
up vote 3 down vote
How can I delete the data inside a table without deleting the table itself?
added by Stefan Lasiewski Aug 31 '10 at 4:02
link
Example of a "truncate table" question. – Stefan Lasiewski Sep 27 '10 at 3:13
up vote 2 down vote
I lost my [ MS SQL asymmetric security key ] in a DB move - how can I recreate it?
added by rlb.usa Jun 24 '10 at 23:34
link
up vote 2 down vote
Are there any non-Microsoft SQL Server certifications for DBAs, and are they worthwhile? [closed]
added by William Jul 8 '10 at 11:12
link

closed as off topic by Jeff, Blake, peeles, edosoft, warren Aug 10 '10 at 2:04

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.

Studying for SQL related certifications is a way to expand your learning, but doesn't seem directly related to this subject area. – Jeff Jul 20 '10 at 16:03
up vote 2 down vote
How can I optimize a search in [database] for the highest numbered record for each cluster of records where clusters are defined by a composite key?
added by Joe Jul 9 '10 at 11:08
link
True story -- I've got to implement search in a PostgreS database where they store older versions of the records in the same table, and don't ever update records to mark them as deprecated ... currently, I'm using Slony to replicate the tables to another database under my control, then using triggers to maintain a 'slimmed down' table that's de-duplicated. (and the table is going to grow by 50k clusters per day, for at least 5 years (assuming nothing goes wrong and they lose the spacecraft). and we have no idea how many records per cluster (3? 10? 50?) just that it'll grow) – Joe Jul 9 '10 at 11:13
up vote 2 down vote
Which hint/locking is the most appropriate for this situation?
added by Robin Vessey Jul 27 '10 at 6:21
link
"None", all hint/locking tips are evil :) Just kidding... the "right answer" is of course... "It depends" :D – Jeff Sep 16 '10 at 19:28
up vote 2 down vote
Which [database / related product] is the best fit for the following problem?
added by xenoterracide, edited by WikiSpeedia hang-around Oct 4 '10 at 19:15
link
2  
I wonder why this is seen as offtopic – xenoterracide Aug 4 '10 at 20:09
Probably because it is more of a wiki based question as it is subjective, there is no one correct answer. – Toby Aug 18 '10 at 22:09
There might be depending on the 'following problem' I can't give a full problem description here. but it doesn't really matter to I don't think in the end the stuff matters much for what the product turns in to. – xenoterracide Aug 19 '10 at 7:07
up vote 2 down vote
How can I do [X] with Microsoft Access?
added by xenoterracide Aug 6 '10 at 19:23
link
This is just fishing to see if MS Access is considered ontopic or offtopic. – xenoterracide Aug 6 '10 at 19:24
And a valid fish it is. – mickeyf Aug 19 '10 at 21:21
up vote 2 down vote
How should I query/modify a [DBMS] table with over a million rows?
added by Toby, edited by WikiSpeedia hang-around Oct 4 '10 at 18:37
link
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
1 2