http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists

I'd give...

Can you script out the db so that I can do some tests here?

Stefan Krzywicki (11/2/2011)

---

I'm trying to find out what a support service is doing for some databases that another group here uses. We got a response that they haven't done run...

Elliott Whitlow (11/2/2011)

---

I think we may be over-thinking this. Licensing is a function of paperwork. I have 5 SQL 2008 Standard servers and 5 SQL 2008 Standard licenses....

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...

Try dropping the sum() / group by.

Then use outer apply to get the total.

That should boost it by a heck of a margin.

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

derekr 43208 (11/2/2011)

---

Would a maintenance plan that...

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...

Well yes. If you were to update stats every 5 seconds, the plans of the updated objects would never stay in...

Ask someone who does. Can't do anything without that.

What does it say in the execution log (SSRS DB)?

TX

Do you have a link that details that info? I'm sure a lot of people might need that info in the near future.