If I get some time. I'm not quite sure whether that tells me a lot, since not only is the data a different size but all the statistics tables...

No, it was quite normal looking. I experimented a bit with some hints forcing it to table scans or changing index usage as part of tuning it up, without...

Thanks, but to some extent client side changes sort of defeats the point, since what I'm trying to fix are all the people out there who might not know to...

If it's a serious question I'll try to answer, because I was fascinated by the title of this post and read it as well.

Largish companies have many vice presidents. ...

I hate access and think it is a form of a virus, however....

You might try forming a temporary table of of the list of duplicates then deleting them all at...

I think it's a bug in SQL. Though I'm not sure what kind.

I redid it as a stored procedure, and it creates the procedure (and presumably compiles it) in...

Do you mean the address of an inbound connection? I have never been able to find a way to do that from T-SQL. You can get the mac...

I think this question is somewhat ambiguous, as the error also happens often and somewhat randomly.

We have chased this error over a year or so. It appears in a lot...

We have had this sort of problem as well, but we are in native mode AD on W2K. The main place this has come up is in Exchange and...

1) Microsoft Access. It works too easily with SQL Server, but at the same time works too poorly. The result is way too many peoeple want to use...

I'll give a different slant on the "pick any IT job".

I have had several people work for me who I hired for X, and who wanted to do Y and...

That is interesting, and thanks for the pointer to see how it considered these.

In our case, we are generally calling the SP or UDF from a command string in ADO.NET...

Re Scott's: The procedure can have only one execution plan, and my guess is that the compiler assumes all parameters will be non-null and choses indexes accordingly.

I...

Indeed. We're very sensitive to the Dynamic vs. non issue because about 90% of what we do is DSS type stuff, that is basically:

- Put up a screen with...

I guess "All general statements are false" might be a paradox, but I like the statement.

The IsNull usage is an intriging syntax to get rid of the OR, but I...