Viewing 12 posts - 9,376 through 9,387 (of 9,387 total)
I don't know if you care, but database mail sends outgoing mail only. The recipients need to understand that if they try to reply, it won't be deliverable unless...
January 16, 2013 at 12:45 pm
If you're thinking of a Word Mail Merge, I don't know of a way you can do that exactly. SQL does have outgoing mail functionality by way if the...
January 16, 2013 at 6:16 am
Agreed. Not everyone is obsessed with ISO standards.
January 15, 2013 at 1:18 pm
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...
January 15, 2013 at 12:45 pm
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...
January 15, 2013 at 11:48 am
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...
January 15, 2013 at 6:15 am
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%....
January 14, 2013 at 1:20 pm
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...
January 14, 2013 at 12:55 pm
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...
January 14, 2013 at 12:11 pm
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...
January 14, 2013 at 12:02 pm
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...
January 14, 2013 at 11:58 am
Grant Fritchey's book SQL Server Execution Plans is also an excellent resource for learning how to tune your troublesome queries.
October 29, 2012 at 12:42 pm
Viewing 12 posts - 9,376 through 9,387 (of 9,387 total)