Viewing 15 posts - 1,546 through 1,560 (of 18,923 total)
November 2, 2011 at 3:28 pm
jared-709193 (11/2/2011)
This article may have something to do with it... http://msdn.microsoft.com/en-us/library/ms187087.aspx i.e. Round-robin can't expand first file so it will not expand second? Just a quick thought...Jared
I'd give...
November 2, 2011 at 11:36 am
Can you script out the db so that I can do some tests here?
November 2, 2011 at 10:59 am
Stefan Krzywicki (11/2/2011)
November 2, 2011 at 10:40 am
Elliott Whitlow (11/2/2011)
November 2, 2011 at 10:24 am
Looks fine but that's untested on my end.
I would possibly use not exists because it's clearer to me and it can't fail if a name is null. I don't...
November 2, 2011 at 9:04 am
Try dropping the sum() / group by.
Then use outer apply to get the total.
That should boost it by a heck of a margin.
November 2, 2011 at 9:01 am
Might be better like this =>
SELECT database_name, MIN(backup_finish_date) AS FirstBackup
FROM msdb.dbo.backupset
WHERE [type] = 'D' --Full backup
GROUP BY database_name
ORDER BY database_name
November 2, 2011 at 8:59 am
derekr 43208 (11/2/2011)
viiki.seth (11/2/2011)
If there is a job to purge bakup history, the query *might not* give you database names whose log backups have been taken.
Would a maintenance plan that...
November 2, 2011 at 8:47 am
Depends how you do it.
If you create the indexes, THEN take a log backup.
And then restore all the way to that last log backup then yes they'll be available.
The backup...
November 2, 2011 at 8:45 am
Lexa (11/2/2011)
So basically you cannot "over" update statistics, right?
Well yes. If you were to update stats every 5 seconds, the plans of the updated objects would never stay in...
November 2, 2011 at 7:26 am
Ask someone who does. Can't do anything without that.
November 2, 2011 at 5:58 am
What does it say in the execution log (SSRS DB)?
November 2, 2011 at 5:47 am
Do you have a link that details that info? I'm sure a lot of people might need that info in the near future.
November 2, 2011 at 5:34 am
Viewing 15 posts - 1,546 through 1,560 (of 18,923 total)