Farhan -

I've seen many bugs with the Optimizer. One of them was logged (3 years ago) to Microsoft and never solved .

Hope you...

Hello Ryan,

My optimizer is like yours...

Just to be more acurate: I didn't say that queries that are covered by an index are not...

Hello Ray,

I'm not aggree with you...

A query does not have to be "covered" by an index all the time.

Even if you do a SELECT * From a table and you...

Thank's Peter for your input.

But as I can see the InvariantCulture is related to english (codepage 850 or 437 ??? not sure, not clear) and this is not what we...

Jonathan,

Error logs are generated normally... I also tested if the SQL Server Agent service startup account was able to write in that directory: it works.

Thank's for your help,

Carl

Hello Jason,

No unfortunately this is not the case.

Best regards,

Carl

Thank's for your reply...

But all the event log (Application, security and system) are set to "Overwrite events as needed".

Also our server reboot every week.

Regards,

Carl

Ok, thank's Steve...

I was not clear enought in my first question.

Brest regards,

Carl

Hello Steve,

Are you talking about the beta 2 version of Yukon?

Me, I am talking about the next version of SQL Server not a beta version.

Here is what I read about...

Hello Chris,

I re-installed Yukon and still have this error.

Don't know why.

Regards,

Carl

Jared,

you were right, the developper who made those two programs has made mistakes.

Now we have the correct Exception: Transaction (Process ID %d) was deadlocked on {%Z} resources with another process...

Alamir,

"Timeout expired" and deadlock are not the same.

You can reach a timeout without having a deadlock situation.

Those are two different concepts.

Carl

Hello Jared,

As you mentionned we are not interested at all to rely on lock timeout for the deadlock handling.

But we did two little programs to test a deadlock and the...

Hello Frank,

We discover something really interesting : On SQL Server 7.0, no matter the way we used ADO.NET, it is always sent to the...

Frank,

Today we will make some other "isolated" performance tests, but since now we cannot see much difference between those two.

I will post the result later today if I have the...