Today I was curious to see some details about access to my domain and my Blog and I've run a SQL query on the blog database to extract some data about comments and posts.
My idea was to monitor how the number of posts and the number of comments are distributed during the 24 hours a day. The SQL query that I've run on my database is this:
SELECT DayHours,
AVG(CONVERT(decimal(5,0),PostCount)) as AvgPosts,
SUM(PostCount) as TotalComments,
COUNT(*) as BlogEntries
FROM
(SELECT DATEPART(hh, DateAdded) as DayHours,
(SELECT COUNT(*) FROM blog_content bc2
WHERE bc2.posttype = 3 AND bc2.blogid = 0 AND
bc2.ParentID = bc.ID) as PostCount
FROM blog_content bc
WHERE posttype = 1 AND blogid = 0) as SOWBlog
GROUP BY DayHours
WITH ROLLUP
and these are the results:
1) This is the distribution of my average post number for the hours in a day... seems that I love to post at 18PM and 11AM.
2) This is the distribution of the number of comments I've received for the hours in a day. Seems that people loves to comment my blog at 4AM (and sleeping???) and from 8AM to 11AM.
If you've access to your Blog database, try to run the query above and you'll discover some curious results. 