Chapter 11. Working with Temporal Data

It's probably fair to say that time is a critical piece of information in almost every useful database. Imagining a database that lacks a time component is tantamount to imagining life without time passing; it simply doesn't make sense. Without a time axis, it is impossible to describe the number of purchases made last month, the average overnight temperature of the warehouse, or the maximum duration that callers were required to hold the line when calling in for technical support.

Although utterly important to our data, few developers commit to really thinking in depth about the intricacies required to process temporal data successfully, which in many cases require more thought than at first you might imagine. ...

Get Expert SQL Server 2008 Development now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.