Browse by Tags

• date
• datetime
• gaps
• islands
• Performance
• SQLCLR

• T-SQL Tuesday #001: Exploring "Fuzzy" Interval Islands Using SQLCLR

  When 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 Read More... Posted Tuesday, December 08, 2009 3:13 PM by Adam Machanic | 2 Comments Filed under: date, datetime, gaps, islands, Performance, SQLCLR, time, T-SQL Tuesday Attachment(s): AdamMachanic_TSQLTuesday_ActiveProducts.zip

• Invitation to Participate in T-SQL Tuesday #001: Date/Time Tricks

  T-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 Read More... Posted Monday, November 30, 2009 1:47 PM by Adam Machanic | 57 Comments Filed under: date, datetime, time, T-SQL Tuesday