Similar articles
EXPLAIN EXTENDED
Join on overlapping date ranges
This post is inspired by a discussion with John Didion: Is there any way to optimize the query for overlapping ranges in MySQL if both ranges are dynamic? I have two tables, each with integer range c...
EXPLAIN EXTENDED
Date ranges: overlapping with priority
Answering questions asked on the site. Jason Foster asks: We have a table of student registrations: Students student_code course_code course_section session_cd 987654321 ESC102H1 Y 20085 99876...
Journey to SQL Authority with Pinal Dave
SQL SERVER – Parallelism Query in Database
I recently came across two interesting questions asked by Feodor over here. He has asked very interesting questions. Please check them as follows: If I have a dual core computer and I would like to ge...
Journey to SQL Authority with Pinal Dave
SQL SERVER – Comic Slow Query – SQL Joke
Community TechDays at Ahmedabad was a great successful event. In fact, this can be considered the biggest event held in Ahmedabad thus far along with the community. I have posted a detail report of th...
ASP.NET Weblogs
ASP.NET MVC: Helper method to display date ranges
I have events web site where I want to show events start and end time to visitors. I wrote simple extension method called DisplayTimeRange() to display event time range on user-friendly manner. My goa...
Gunnar Peipman's ASP.NET blog
ASP.NET MVC: Helper method to display date ranges
I have events web site where I want to show events start and end time to visitors. I wrote simple extension method called DisplayTimeRange() to display event time range on user-friendly manner. My goa...