Divide by 0 issue on the sys2.logs_usage view

I ran into an issue where some of the logs were not used yet whice then cause a divide by zero error. Below is my code on how to handle this issue. WITH cte as ( SELECT name, db.log_reuse_wa...

Id #7346 | Release: None | Updated: Mar 15, 2013 at 3:17 PM by KeithClaypool | Created: Mar 15, 2013 at 3:17 PM by KeithClaypool

sys2.stp_get_databases_space_used_info and the sp_MSForEachDB unreliability

Because of the sp_MSForEachDB unreliability (for example when there are a lot of databases) I would suggest you to remove it from the "sys2.stp_get_databases_space_used_info", replacing it with a m...

Id #6894 | Release: None | Updated: Feb 13, 2013 at 4:06 AM by FrancescoQuaratin | Created: Apr 16, 2012 at 3:30 PM by FrancescoQuaratin

  • 1-2 of 2 Work Items
    • Previous
    • 1
    • Next
    • Showing
    • All
    • Work Items