I have a vbscript which uses the LogParser Com object (yay for logparser) to trawl IISW3C and summarise total bytes sent and recieved for the most part it works great it inserts traffic daily for multiple sites into a db. However I recently removed the data for one site so there is no record of it.
The query I use to get the data first checks the db to see when a value was last recorded for a site then if there is no record for that site in the db then it uses the query below
SELECT TOP 1 TO_STRING(TO_TIMESTAMP(date,time),'yyyy-MM-dd') as W3CLogDate,date
FROM <SiteID> ORDER BY date
At present I am receiving the error below
CLogQueryClass: Not enough memory [Not enough storage is available to complete this operation.]
It seems there are 21gb of httplogs for this site
Anyone have a good suggestion for a better way of determining the first log date?