Hello,

I don´t know if you are familiar, but you can try to create a partition function to store the data in partitions. I not every percent shore but i think...

Hello,

The "AND" in de case is clearly wrong because if the day of the BirthDay is inferior to the one obtain in the GETDATE() it will always return 0.

CASE...