Split date range without Calendar table

Hi Uri,

it really doesn't matter what group or count or sum is used. Problem is that I'm joining small Calendar rable with huge Fact table and that is the slow part. Imagine 1 month sliced into 1h periods ( = 744 periods) and join it with 500.000.000+ records table... it works but it takes time to complete. I was wondering if there is any other solution for this?

Thanks,