Part2:

The other common use for IMDB is Complex Event Processing. The desire to process data first & only log some, none or all of the changes async. ie have minimal latency when passing messages or similar types of transactions.

For this use, read up on the StreamInsight feature of the upcomming SQL 2008 R2 Release.

Dave