Sure, but when you've encountered similar enough problems to solve enough times - you can often skip the analysis and use a "good enough" solution that works well enough in...

1) Compression Tools - the free tools do such a great job, why bother paying for something? 7zip works great and I usually get a SQL backup down to...

Alternate for generating the week/day pairs (probably need to adjust dates to start of school year, rather than beginning of calendar year):

WITH dates(DT) AS

(

SELECT CONVERT(date,DATEADD(day,-7,GETDATE())) as DT

UNION ALL

SELECT DATEADD(d,1,DT)

FROM...

You could also use the STDistance function on 2 geo columns/objects?