Hopefully this will get you started

http://www.sqlservercentral.com/articles/T-SQL/63681/

Dave

Perry Whittle (10/12/2011)

--------------------------------------------------------------------------------

Dave Brooking (10/12/2011)

--------------------------------------------------------------------------------

We had a similar problem a while back, where the SQL server restarted every 4 days. It turned out that a new version of the antivirus...

We had a similar problem a while back, where the SQL server restarted every 4 days. It turned out that a new version of the antivirus software had a 'memory...

Jen,

I think the answer may lie with the Inscope function. This isn't something I've previously used, so I can't offer any insights into its usage. I'll have a play with...

Jen,

I'm not fully understanding the requirement. The highlighted columns do add up to 100% (Q4 adds up to 99.99%, but probably due to a rounding error). Are you saying that...