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

LOL, in an interview, I'd think the CTE, or a short WHILE loop would make sense, having the person talk through what they're doing. This isn't a test of great...

One other thing is that "common answers" change over time. The T-SQL langauge has changed (index defrag v alter index) over time, and at the rate MS releases versions, I...

I visit a lot of forums and they have similar issues. Most people won't read a "sticky" post at the top of the forum. They just don't pay attention. Those...

The ask.sqlservercentral.com is supposed to help here. Not sure if it is.

Not sure there's an easy solution for this. Most people just want to ask a question and get an...

Are you "loading" data or is this users making changes? If it's the latter, which is what most systems have, it's impossible to do anything other than guess without historical...