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.

All true. Honestly we only allowed it to pass because all the answers we were getting were so damned pathetic. We also allowed people count dropping and recreating the proc...

I just wish it was only people interviewing for their first jobs. We're getting people with 5-8 years of "experience" that don't know the answer. I'd attribute it to nervousness,...

I'm sorry, I've only got 2005 installed on my systems these days. I can't readily test this.

True.

Hey, thanks for the reply to the article. Yes, I'd like to see a mechanism for unit testing SSIS as well. I think it'd probably be more useful than testing...