Hi! I'm a monkey who knows a bit about SQL and every now and then I intend to post a few tips on this blog.
Rolling windows and visitors since midnight
Do you ever use a rolling 24 hour window to monitor live hit statistics on your website? It can give an good snapshot as to how popular your site(s) currently are, but can also leave a sinking feeling if the count drops throughout the day.
