Not long ago I came across a graph plotting acceptable system downtime and acceptable data loss in an easy-to-understand format in the context of disaster recovery. The idea of the presentation was that acceptable maximum downtime limits and maximum data loss limits should be agreed with the business/customer in the SLA, and these thresholds guide the DBA's disaster recovery strategy.
I've seen this graph/concept before in a couple of places, and it has a specific name, too, but it's eluding me. Does anyone know what I'm talking about and can post a link or more details (or did I just dream the whole thing up?)
---Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!
Want to get the best help? Click here http://www.sqlservercentral.com/articles/Best+Practices/61537/ (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.