Adam Machanic : gapshttp://www2.sqlblog.com/blogs/adam_machanic/archive/tags/gaps/default.aspxTags: gapsenCommunityServer 2.1 SP2 (Build: 61129.1)T-SQL Tuesday #001: Exploring "Fuzzy" Interval Islands Using SQLCLRhttp://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/08/t-sql-tuesday-001-exploring-fuzzy-interval-islands-using-sqlclr.aspxTue, 08 Dec 2009 19:13:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:19621Adam Machanic2http://www2.sqlblog.com/blogs/adam_machanic/comments/19621.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=19621When working with time intervals, we often want to ask a couple of basic questions: Which time periods are not covered by our intervals? These are known as "gaps". What are the time ranges that we are fully covering? These are known as "islands". If you're...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/08/t-sql-tuesday-001-exploring-fuzzy-interval-islands-using-sqlclr.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=19621" width="1" height="1">PerformanceSQLCLRdatetimedateT-SQL Tuesdaytimegapsislands