TSQL Challenge 37 - Calculate the downtime and duration of servers based on the monitoring log
This is a challenge to identify the downtime of servers from the log data generated by a monitoring application.
http://beyondrelational.com/puzzles/challenges/41/calculate-the-downtime-and-duration-of-servers-based-on-the-monitoring-log.aspx