Recent Posts

Generate Random Date With Starting Point

less than 1 minute read

If you want to create sample random samples when dealing with date calculations to test your results, you can easily create a start and end point of randomly...

Finding Groups - Consecutive Months

less than 1 minute read

A step by step explanation on one way to get a consecutive period of months, which could easily be adapted to days, years, or other values. I’ll continue on ...

Eliminate Overlapping Dates

less than 1 minute read

I was looking for an efficient way to eliminate overlapping days when provided with a historical table that provided events that could overlap. In my case, I...

Scalar functions can be the hidden boogie man

less than 1 minute read

Ran across a comment the other day that scalar functions prohibit parallelism for a query when included. I thought it would be worth taking a look, but didn’...