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...

That's a highly incomplete link, and it's what was said before.

The hard part is determining

- records/month

If you know that, then it's easy. But getting that number can be very...

Ditto

Sorry I misssed it

richard-674310 (2/22/2010)

You might want to consult your HR department on this - if you have one. I think it may be illegal (in the UK) to discriminate on NON-OBJECTIVE...