Had to really dig through the cob webs on this one. Great piece of trivia:rolleyes:

Question is terrible!

Took a guess because the error that should have come up was not listed, so had to guess.

Had you at least tested your QOD before posting it,...

Good question, thanks

Hugo, very good question.

Reading my question now, many weeks after submitting it, I am wondering if I even should have written it like this - QotD should test SQL understanding,...

Also, to use Paul Randall's method from a couple of weeks ago - this is for my point I lost

I must add my own .02 to this thread. I to come up with the correct answer being wrong. Using the reference given, I see that some of the indexes...

What level of authority does the new startup login have?

I am confused. Contractually, are you responsible for the...

That is truely a great attitude. Did they understand what needed to be done to maintain the database as well as the consequences if they didn't?

River - First it sounds like as Paul stated the database is corrupted or possibly you are not on the same version of SQL Server as the customer. Have you...

I may be a bit slow on this, and am not going to be as adament on it as Dave, who has been having this very same arguments for a...

Not on a simple select *

Unless possibly there is a problem with the statistics on the clustered index.

I...

The original comment was about records being loaded using bcp into a table with no PK or other indexing, and adding it after. (This was my original comment to...

one more example:

Removing the PK from the id field, and placing it on your x field returned the following:

x z...