Search results matching tag 'Time'

Re: password too restrictive

8xup68 — Tue, 21 Jul 2009 23:12:18 GMT

[quote user="qbernard"]Hehe.. I don't have the same password nor pattern for every sites I associated with :) You got 1 more year to go before I change it.[/quote]

Inserting higher resolution dates into SQL Server 2008 datetime2 type

MikeGale — Thu, 14 May 2009 06:35:12 GMT

I have some time data in logs with a sub-second time resolution.

I can get this safely into log parser using the iTsFormat setting.

When I put that into SQL Server 2008 I have (so far) gotten the times in seconds (loss of resolution). The target field is datetime2 (not datetime).

How do I preserve the resolution when inserting the data?

Log lizard error and query help

blueriver — Thu, 04 Dec 2008 22:03:52 GMT

Hi:

Need a little help as I'm not very good at the sql language as yet.

This is the query I'm using:

SELECT date,time,c-ip,s-port,cs-method,sc-status,cs-host,cs-uri-stem FROM
c:\iislogfiles\W3SVC1\extend1.log,
c:\iislogfiles\W3SVC30103697\extend1.log,
c:\iislogfiles\W3SVC54472458\extend1.log,
c:\iislogfiles\W3SVC54583666\extend1.log,
c:\iislogfiles\W3SVC620987851\extend1.log,
c:\iislogfiles\W3SVC978284352\extend1.log,
c:\iislogfiles\W3SVC987274646\extend1.log,
c:\iislogfiles\W3SVC1225455001\extend1.log,
c:\iislogfiles\W3SVC1173546801\extend1.log
order by date,time

What I would like to do is convert the GMT time into my time (EST) and also have the output order reversed so that the most recent entry is first and not last.

Also, I noticed that while using Log Lizard, if the first log file in the query does not exist, I get an error.

Thanks for looking at this.

Using LogParser to calculate Think Times for performance testing

jborneman — Tue, 18 Nov 2008 15:59:24 GMT

New to log parser but looks like a great tool. Anyone here use it to calculate real world think times for given requests/pages for use in VSTS load/performance testing? I tried doing some searching of the forum without luck, so hopefully I'm not asking an already answered question.

Thanks!

How to deal with this problem ?

vikinger — Thu, 06 Nov 2008 14:08:21 GMT

logparser i:iisw3c -q:on "select distinct c-ip from ex081103.log where to_timestamp (time) = timestamp ('02:18:49','hh:mm:ss')"

Error: detected extra argument "select distinct c-ip from ex081103.log where to_timestamp (time) = timestamp ('02:18:49','hh:mm:ss') " after query

Re: Our new site is live...

JoshStodola — Fri, 11 Apr 2008 22:24:55 GMT

As expected, you guys took a perfectly good design (the old one) and turned it into an eyesore (this one). It's becoming quite the forte for Microsoft Community sites. Don't worry about bugs, just re-design the damn thing! Idiots.