Looks like it rolled over to the 1 million mark overnight!

Kev

Schadenfreude-Mei (12/2/2008)

---

And in response to kevriley, I think you likely get in hot water for making changes to Local Security as it would effect all none admin users of that...

You can do this by amending the Local Policy.

Obviously only do this if you are comfortable using the Policy Editor

Start - > Run - > gpedit.msc

navigate to User Configuration -...

Hi all,

thanks for all your comments, very encouraging!

Jeff- sorry the title didn't meet expectations - I was just trying to make it more exciting!

Roger - I take all your points...

yisaacs,

the @Result parameter is holding the datetime from your query.

You then select the number of seconds different from current time but don't affect @Result at all.

Your IF is then using...

I am in the UK, where we currently are in GMT (any daylight saving time is over).

The bottom of the page states

but...

dhayes,

I guess you are new to SQL 🙂

The first time you ran the script, you were creating a stored procedure, teh scond time errored, as you found out, because the...

Mark,

are you sure you are running this against a SQL2005 instance?

Kev

I guess thats a good thing in a cross-technology standard!

Kev

Gail, can you explain what you mean ??

Kev

smunson,

I think Steve means on the podcast....

Kev

wouldn't implicit conversions affect both the production and test environments?

memory pressure - Clive...

Can you force a recompile on the Production server (WITH RECOMPILE)?

Is parallelism turned on? Is it configured (MAXDOP). Does it appear in either of the execution plans?

Any chance of...

Was this on both the production(gulp) and test servers?

Kev

Another thought - are the indexes the same? and is the data the same?

Kev