My bread and butter is and always has been data stored in relational databases. I keep seeing a lot of material on key-value storage (also known as the NoSQL movement) but haven't had as much success finding resources on how to move from relational to non-relational. Any suggestions? [more inside]
posted by Deathalicious on Jul 10, 2010 - 10 answers

Can I specify the order in an ORDER BY clause in a SQL Statement? If not then what is the best way of doing the following query? [more inside]
posted by xetere on Feb 19, 2009 - 9 answers

I have a problem joining three tables in MYSQL. [more inside]
posted by dydecker on Aug 21, 2008 - 19 answers

I need to import a database into MS SQL but I do not want to end up with a transaction log as large as the database. What's the best way to do the import? [more inside]
posted by odinsdream on May 29, 2008 - 4 answers

What's the best way to keep data one way synchronized between an internal Mircosoft SQL Server database and a web facing mySQL database? [more inside]
posted by advicepig on Apr 3, 2008 - 9 answers

How many database reads/writes are okay per web page view? Also, what is better, big tables or lots of join tables? [more inside]
posted by markovich on Nov 16, 2007 - 13 answers

What resources exist for non-techy social scientists who want to use relational databases to store their data, but don't know how? [more inside]
posted by jacobm on Dec 24, 2005 - 7 answers