Database Olympics: File Maker Pro vs. MySQL! Help us pick a database system (Anko or Firebrand). Which do you think is superior to run a print publication database? [more inside]
posted on Aug 19, 2008 - 6 answers

FrontPage Filter: How do I find the SQL database the dropdown list is pulling from? Difficulty: Fixing a site I didn't design. [more inside]
posted on Aug 12, 2008 - 13 answers

I'd like to reconstitute a years-defunct wiki I used to collaborate on. I've contacted the principals, & our searches for the database backup have come up empty so far. Without having the original database, the simplest path appears to be taking the html & transforming it into, say, an sql dump. So - how do I do that? Are there any MediaWiki, database, or Perl trails to follow?
posted on Aug 6, 2008 - 6 answers

Fixing whitespace: Can someone translate 's/ */ /g' into T-SQL? [more inside]
posted on Jul 30, 2008 - 2 answers

SQLFilter: I'm struggling with a specific SQL query. I have 2 tables, 'questions' and 'answers', which are linked by a field in answers. I would like to select the questions which have the most answers in the last 24 hours. [more inside]
posted on Jul 19, 2008 - 2 answers

Another SQL question (*sigh*), but this time a bit more complicated. [more inside]
posted on Jul 15, 2008 - 7 answers

I've got what should be an uber-simple SQL question.... [more inside]
posted on Jul 7, 2008 - 8 answers

Computer-ese for the illiterate: What's all this SQL that's gotten all over everything? Whadizzit? [more inside]
posted on Jul 7, 2008 - 10 answers

Are there SQL statements that return table names and field names for given table names in MySQL Server (5.0.22)? [more inside]
posted on Jul 7, 2008 - 8 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 on May 29, 2008 - 4 answers

We use clinical software that uses a MS SQL database. It has a five million records weighing in at 40 GB. The software doesn't have a mobility option but we need one. The company has it on their feature request list but its at least 3-5 years away. HELP. [more inside]
posted on May 29, 2008 - 20 answers

I'm looking for a fuzzy text-matching algorithm for an autocomplete widget. [more inside]
posted on May 10, 2008 - 9 answers

Which version of PHP should I start to learn, and how? I know HTML and CSS, and intend to build with Drupal (or similar) and its many extensions. [more inside]
posted on May 4, 2008 - 12 answers

MySQL sorting issue. When I have "first name" and "last name" columns, and I'm sorting primarily by "last name." Some entries have only a "first name," and rather than have those end up at either the start or end of the sort, I'd like it to pretend the "first name" IS the "last name" and sort accordingly. Is there a way to do this with the SQL SELECT statement or should I just edit the data? [more inside]
posted on May 2, 2008 - 8 answers

How much SQL normalization is too much? [more inside]
posted on Apr 25, 2008 - 21 answers

In a SQL query that returns totals by date, how to interpolate dates where there are no results? [more inside]
posted on Apr 20, 2008 - 7 answers

How can I do a Rails find JOIN without SQL, using the two tables' existing has_and_belongs_to_many relationships? [more inside]
posted on Apr 18, 2008 - 5 answers

I need help with a SQL CTE which works in SQL 2005 but doesn't in Business Objects. [more inside]
posted on Apr 18, 2008 - 1 answers

I have an Access 2007 database with client information and I need to make it do two relatively simple tasks. [more inside]
posted on Apr 11, 2008 - 6 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 on Apr 3, 2008 - 9 answers

What is the "state of the art" with respect to Python on Windows for Active Directory administration and interfacing with MS-SQL 2000/2005/2008? [more inside]
posted on Apr 2, 2008 - 5 answers

Why isn't a query in Access returning the correct data compared to the equivalent query in SQL Server. More inside. [more inside]
posted on Mar 31, 2008 - 11 answers

Help me understand MSSQL logs... At least enough to do what I need to do. [more inside]
posted on Mar 28, 2008 - 1 answers

MySQL question: Given a table with a datetime column and several additional columns which may or may not be null, is there an easy way to select the most recent previous non-null value of each column given a specific date? [more inside]
posted on Mar 13, 2008 - 10 answers

Through a series of dumb (though possibly dumb-lucky) mistakes and mysterious errors followed by disk failure, I am piecing a SQL (2005) server back together from not exactly optimal ingredients. I need help. [more inside]
posted on Mar 2, 2008 - 1 answers

SQL Filter: What query can I use to count the number of times a word appears in a text field? [more inside]
posted on Feb 21, 2008 - 6 answers

How does one get their head around OLAP? [more inside]
posted on Feb 10, 2008 - 4 answers

How does Facebook handle or simplify the presumably complicated DB queries involved so that me loading my page doesn't bring it to its knees? [more inside]
posted on Feb 4, 2008 - 27 answers

Some colleagues and I will soon be leaving our current employer and starting a new company. How can I best replicate our current relational database/SQL abilities from scratch? [more inside]
posted on Jan 23, 2008 - 11 answers

What DBA certification should I pursue? MS, Oracle, something else? [more inside]
posted on Jan 15, 2008 - 3 answers

How can a fool make a table in an Access database reference another table, using SQL and ASP? [more inside]
posted on Jan 11, 2008 - 10 answers

Second-Day-on-the-Job Panic: How can I get my mostly-self-taught, LAMP-loving self to be more confident and capable with developing corporate/enterprise applications? [more inside]
posted on Jan 8, 2008 - 11 answers

Please help me understand what happens when I click the cancel query button in SQL Server Management Studio. [more inside]
posted on Nov 29, 2007 - 3 answers

Been banging my head against the wall on this the whole day. I need a way to select & sort data from a single MySQL table, but it's a little bit more complicated that it seems. [more inside]
posted on Nov 23, 2007 - 14 answers

Please help me with a giant SQL-ish mess. I need a better solution than MS Access for dealing with millions of records and building queries. [more inside]
posted on Nov 19, 2007 - 12 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 on Nov 16, 2007 - 13 answers

Sum of data for all months, including months with no rows, in MySQL? [more inside]
posted on Nov 15, 2007 - 7 answers

I have a set of dates/times in a MS SQL table that lack a timezone offset. I want to convert them to UTC, but I have to be mindful of Daylight Time for each of these dates (they're in the future). How can I convert them to UTC correctly? [more inside]
posted on Nov 13, 2007 - 3 answers

ColdFusion MX 7 and Microsoft SQL Server 2005. There's a lot of unvalidated parameters in our CFQUERYs. But, I'm told that putting the parameters in single-quotes will prevent injection attacks, because of the way ColdFusion escapes single-quotes. Is this foolproof, or do I have to go in and validate everything with CFQUERYPARAM tags?
posted on Oct 22, 2007 - 3 answers

Can I, should I, make a career change into database design? [more inside]
posted on Sep 25, 2007 - 16 answers

Where can I get some noob information on how to read/write simple database tables with ASP? [more inside]
posted on Sep 25, 2007 - 4 answers

SQL SERVER - I'm not a SQL script guy, but I've got a SQL script problem. [more inside]
posted on Sep 17, 2007 - 6 answers

What is the prefered way to represent status changes over time in a relational database? [more inside]
posted on Sep 4, 2007 - 17 answers

From two MySQL tables, I need to fetch a list of customers who DOES NOT have an invoice issued to them within the past 2 months. More details about the table structures inside. [more inside]
posted on Sep 3, 2007 - 10 answers

Any SQL / math ninja's on the green fancy a quick challenge..? So I've got this table containing number pairs, right, and I need to compute all the possible combinations. [more inside]
posted on Aug 15, 2007 - 25 answers

I'm trying to merge simple contact data from a bunch of single tables into one big text (csv) dump. The problem is that not all fields are present for each user. e.g. one user may be missing an email. Because of the missing field, my current (big and ugly) sql query will not return all the rows. [more inside]
posted on Aug 2, 2007 - 13 answers

Looking for some guidance in building an "advanced search" query using XML and optional multi-value parameters. [more inside]
posted on Jun 26, 2007 - 6 answers

Can FileMaker read from a SQL database? I've talked to (SQL) developers and they can't find a way to do it. [more inside]
posted on Jun 21, 2007 - 8 answers

Need some help with MS SQL text replacement. [more inside]
posted on Jun 18, 2007 - 15 answers

What's the best way (using the internet, and/or books) to learn how to query SQL databases with Ruby?
posted on Jun 10, 2007 - 3 answers