|
|
-
dishdy Solved 23 Days ago through Puzzles
Uses cte to walk across a tree presentation of all paths. Will not win on performance. But found this approach interesting.
|
-
dishdy Commented 1 Months ago through Just Learned
Boy, do I agree with vanne040's last statement!!!...
|
-
dishdy Created 1 Months ago through Puzzles
The challenge is to find the minimal set of intervals without creating gaps.
There is a table with groups of redundantly overlapping date intervals where each group has no gaps. Given this table, your job is to find the minimum set of date intervals witho
|
|
|
-
dishdy Commented 1 Months ago through Puzzles
The cpu stats are very good. However, logical reads are high.
|
-
dishdy Commented 1 Months ago through Puzzles
Complements for your excellent performance statistics.
|
-
dishdy Commented 1 Months ago through Puzzles
If had access to SS2012, I would definitely try the LEAD and LAG functions.
In a couple of weeks I'll get a SS2012 installation that's all mine!
|
-
dishdy Commented 1 Months ago through Puzzles
@Adam, I think @castling is using your v3 script.
|
-
dishdy Commented 1 Months ago through Puzzles
What do you get with the performance data published by @Adam (v3) in the discussion area?
|
-
dishdy Commented 1 Months ago through Puzzles
@castling, Any stats you can show us? I'm very curious!
|