In response to Adam's new series of T-SQL Tuesday, I wanted to write that there are faster ways to get the data in a set-based manner without resorting to SQLCLR.http://sqlblog.com/blogs/adam_machanic/archive/2009/12/08/t-sql-tuesday-001-exploring-fuzzy-interval-islands-using-sqlclr.aspxMany companies today still think of SQLCLR's as security ...

During the XML Optimization presentation today I'll refer back to the sample code posted at http://www.apress.com/book/downloadfile/4021.  I'll also update this post with additional sample code by tomorrow. UPDATE: The PowerPoint presentation and sample code are attached to this post in the ZIP file. Jacob Sebastian's book ''The Art of ...