I agree with GSquared - combine things logically into groups. I've had deployment scripts of several thousand lines that I've run to release things to production before. When...

If join date is the date someone joined a group, then just populate it when you first insert your row. If you want it handled by the database for...

Before you start whacking your outgoing email history, you might want to ask yourself if you're going to need it. I'm not saying you do, but rather that you...

I don't know if this helps, but we have a SQL Server with 72 GB of memory. It typically runs between 85% and 88%, but occasionally spikes to 92%....

Now I see the trouble with what you were asking. Does this give you what you're after? It uses a correlated subquery [child] to concatenate the list for...

The fields can be concatenated together however they're needed. I certainly don't claim to know MySQL at all - I was just offering a SELECT statement that would return...

Grant is right - you need to check your data types.

Also, you cannot have an ORDER BY clause in a view. SQL 2000 tolerated it but the later versions...

In SQL Server, you could use the following:

SELECT 'Your performance is ' + CONVERT(Varchar, grade);

I would consult the MySQL documentation under "string concatenation" for details on how it's done in...

Grant Fritchey's book SQL Server Execution Plans is also an excellent resource for learning how to tune your troublesome queries.