Adam Machanic : datetimehttp://www2.sqlblog.com/blogs/adam_machanic/archive/tags/datetime/default.aspxTags: datetimeenCommunityServer 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 TuesdaytimegapsislandsInvitation to Participate in T-SQL Tuesday #001: Date/Time Trickshttp://www2.sqlblog.com/blogs/adam_machanic/archive/2009/11/30/invitation-to-participate-in-t-sql-tuesday-001-date-time-tricks.aspxMon, 30 Nov 2009 17:47:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:19338Adam Machanic57http://www2.sqlblog.com/blogs/adam_machanic/comments/19338.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=19338T-SQL Tuesday is the SQL Server blogosphere's first recurring, revolving blog party . The idea is simple: Each month a blog will host the party, and about a week before the second Tuesday of the month a theme will be posted. Any blogger that wishes to...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/11/30/invitation-to-participate-in-t-sql-tuesday-001-date-time-tricks.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=19338" width="1" height="1">datetimedateT-SQL TuesdaytimeWhat Happened Today? DATE and Date Ranges Over DATETIMEhttp://www2.sqlblog.com/blogs/adam_machanic/archive/2009/10/20/what-happened-today-date-and-date-ranges-over-datetime.aspxTue, 20 Oct 2009 18:21:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:18023Adam Machanic14http://www2.sqlblog.com/blogs/adam_machanic/comments/18023.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=18023A few days ago Aaron posted yet another fantastic entry in his Bad Habits series, this one discussing mishandling of date ranges in queries . This is a topic near and dear to me, having had to clean up a lot of poorly thought out code in the past few...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/10/20/what-happened-today-date-and-date-ranges-over-datetime.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=18023" width="1" height="1">PerformanceT-SQLOptimizationdatetimedate