FWIW, I'd advocate writing SELECT NULL in an EXISTS mainly for the semantics. It feels weird to see * or 1 or even anything in a SELECT list that'll be...

Just to add - JET drivers distributed by default with Windows operating system...

Nice article.

What I found most interesting about this was the remark:

For most environments, having faster stored procedures and reducing any potential CPU pressure is more important than the number of...

Just in case anybody comes here with similar error - it turned out to be a boneheaded mistake of mine...

When I generated the scripts from one machine and applied it...

Okay.

So in for this specific situation, you are only updating only the Driver_No; the Company and Date_Dor fields hasn't changed.

Your query works with the trigger disabled because you could...

pbaldy, yes the same banana. 🙂

Just for clarity, what was the query that you used to update manually the parent and then the child?

I have to confess that I'm a bit confused because I can't see how this could possibly work.

The way I read it, you're cascading the changes to the key {Company,...

Nevyn, if it is true that source also would give truncation errors, then it makes default even more stranger - the default is to use string with length of 50...

Thanks. I had the impression that one should use execution plan to get an idea of how well it'll perform for different applications whereas timing the result would be too...

Cool, thanks, Gail.

From your response, I also now wonder if I'm doing it wrong by trying to compare the execution plans since you seems to be simply looking at the...

Hmm. I had intended it as a general question. However, I acknowledge your point about schema having influences. So, for a need of a handy test data, I turned to...

Also, to clarify --

L' Eomot Inversé (11/29/2012)

connection between app machine and database machine. If it isn't, I'm looking at the wrong things - but the error message seems to...

Tom, we're talking at different granularity. My concern is that registry edits you're suggesting is a machine-wide setting and I'm saying it's preferable that it's either an application-wide setting OR...

Tom, if it's a client setting, then that'd mean configuring all clients that runs the front-end software. Wouldn't it also potentially mess with other softwares? I'd prefer that it was...

hisakatama is essentially correct - Access has to be the one to perform the heterogeneous join since it has access to data from both sides (SQL Server knows nothing about...