Thanks, Gianluca,

I hope this isn't supposed to count as a CAN-SPAM inquiry. Just an FYI, posting in a random forum and hoping someone sees it isn't the best way to...

One other thing, if you can get him to talk, ask about once a year, or rare processes that come up after certain events, like the end of the year,

Thanks, John. Hopefully it will be done tomorrow 🙂

I'm not sure it's a SQL problem. I think it's a security problem at this point. SQL just queries AD, if I remember correctly, under the service account permissions. Is...

Want to test with 10mm rows and let us know?

I'd suggest two things.

1) set your instance to use 1434, move a default instance to another port

2) set a DNS entry with an FQDN to point clients to the server....

You are correct, the declare table should stop things. I might be curious to see where someone was going, but the declare cursor would drop someone way down my list...

C'mon, I'm sure you'd end the interview after

DECLARE curNumbers CURSOR

How long could that take?

The one that says pork chop the most :w00t:

It's a good one. I was hoping for more SQL ones in the comics, but they seem to be fairly rare.

All things being equal, you pick the guy with the set based solution. However I've rarely seen "all things equal" between two candidates in an interview. The better the solution...

How do you get rows per day?

The formulas for calculating space are trivial. It's the information gathering that is hard.

You certainly are, and just because there's an article out...

The only way to get this number is to track it. I used to track it by table, but it didn't seem to be a useful metric for me. I...

No argument about the best programmer, and I'm sure I'd miss out on some jobs if this is the only criteria. In an interview, my first thought is solve the...