Ha!

Well, I'm not going for messed up, but it's worth a shot. I'll let you know.

Everything the Guru said and, check the use of transactions in your process. Something seems to be doing some sort of lock escalation within the transaction because blocking, by itself, doesn't...

OK. Weak theory completely destroyed by reality. You can't drop statistics created by indexes and the other statistics just don't seem to be affecting the plan much. More ideas needed.

Something like this?

UPDATE Receipts

SET DateEnd = u.ExpiryDate

FROM UserRoles u

INNER JOIN Receipts r

ON u.UserId = r.UserId

WHERE u.RoleId = 5

I'm thinking I'll try dropping the statistics on a table and see what happens. I'm trying to get a different plan, not just subtle differences in the plan (different row counts...

Hey,

I saw the test you'd outlined so I tried it on my laptop:

WHILE LOOP TEST...

1000000 The final count (just to show work was done)

970 Duration in milliseconds

------------------------------------------------------------------------------

SET BASED...

I worked for one of the software vendors for healthcare products. They're out of business now. We actually had very good developers, but a CEO that thought that IT knowledge...

It comes down to the classic DBA answer, it depends. I've primarily done work for internal applications, code that runs in-house for a company doing X. Platforms I've done that...

I've seen similar behavior. I never saw that in 2000.

I have to agree. In a real interview situation this code would scare me off.

Great response. First, I was joking about actually using this as an interview question. However, the excercise is interesting because it does force you to apply logic and a bit...

I have to say I was really surprised at how much response this little article generated. I dashed it off after we had our fun with it. I didn't think...

Ladies... The signal to noise ratio is starting to drop a bit. This was supposed to be a bit of candy for some intellectual stimulation a little bit different than...

Looks cool. I'm going to pass it out to the team & see what they think.