Viewing 15 posts - 61 through 75 (of 174 total)
SELECT cname,rating FROM customers
WHERE rating= (SELECT MAX(RATING) FROM customers AS abc WHERE abc.`CCITY`=ccity )
The default reference will be the local (sub)query. This means that your inner query (with the MAX)...
June 24, 2013 at 2:53 am
UPDATE TABLE emp SET designation = REPLACE(designation, '(sales)', '(marketing)')
WHERE designation like '%(sales)%';
June 24, 2013 at 2:12 am
Seems there's no real issues then Scott since the majority of the databases are in SIMPLE anyways :hehe:
June 21, 2013 at 3:13 pm
Yeah the ";-)" signalled a joke 😛
No reason to cause waves about it although they're throwing up like 50 of these servers that dont seem to do much & all...
June 21, 2013 at 1:21 pm
Elliot,
The other week I found a database with no backups at all and the 1.7gb database had a 120gb log file because it was in full mode...remote storage is asking...
June 21, 2013 at 12:57 pm
I'm guessing it would actually be used in an OUTER JOIN like in the possible solution I gave~ from what he says the main table doesn't contain saturday/sunday records so...
June 17, 2013 at 10:09 am
How many backup files do you have per database? You're not appending to the same file are you?
Is your File Extention "bak" instead of ".bak"? We use "bak" and the...
June 17, 2013 at 5:15 am
Wouldn't "generate less logging" be more accurate since the logging to re-apply the truncate will also be logged?
June 17, 2013 at 5:09 am
g_demetriou (6/17/2013)
you might want to check that the SQL Agent user has access rights to the folder you are deleting from.
Doesn't the "write" privilege on a folder affect both writing...
June 17, 2013 at 4:38 am
Thanks for the link & help 🙂 The Windows team will raise a change to upgrade it.
Although I'm a little disappointed about not being able to do my first...
June 17, 2013 at 4:11 am
There is DiskKeeper on the server but I don't know if its classed as a "new" version since it's 2010? Apparently there's no encryption software.
I'll ask the Windows team about...
June 17, 2013 at 3:54 am
Could the issue be that it's on 2005 standard edition? Apparently snapshots are only available from 2005 enterprise onwards?
June 17, 2013 at 2:40 am
Perhaps you've checked the box "Create a sub-directory for each database" but in the cleanup task you didn't tick "Include first-level subfolders"?
June 17, 2013 at 2:32 am
I sent my email in a PM but you can just reply to this thread again & I will receive email notifications anyways
June 16, 2013 at 6:54 am
Viewing 15 posts - 61 through 75 (of 174 total)