Actually, I'd like to hear from the 2% who got this correct.

Hi Lynn,

I agree completely; there are lots of jobs that pay more than $50,000 that don't (or shouldn't) qualify as exempt from overtime.

There is currently an incredibly low...

It's funny how this is both timely and dated. The U.S. Department of Labor is in the process of issuing final regulations that will expand the number of employees...

I vote for "allowing written SQL to reflect the person who originally wrote the code". That way, if the formatting looks like it was taken directly from the interior...

Although it completely violates the spirit of the editorial, I would suggest that this

most people make great and interesting choices

should read:

most people make great or interesting choices

Paradox of Choice

Mattie

If there were one thing I'd love to have (back), it's publishing all of the previous day's questions (Database Pros Who Need Your Help) in the daily newsletter. I...

Is it just me, or does this sound like an auditing nightmare?

Mattie

Jeff,

Thank you so much for critiquing my code, it's been incredibly helpful, not just for this project.

I've added the code that does the update of StartDate and EndDate, which is...

Hi Jeff,

Thanks. So is this what I want? It seems to return the correct data (although so did the other code). Changes are in bolded italics. ...

Argh. I was so convinced it was something totally outside my grasp (page splits, clustered indexes) that I never thought to double check the actual fields ("The simplest explanation...

Hi Drew,

I had sort of realized that, and tried to implement the 'Quirky Update' running total solution referenced in that article (19 pages printed), but probably attributable to my lack...

That's exactly it. Thanks so much.

Mattie

I haven't read this http://www.amazon.com/Paradox-Choice-Why-More-Less/dp/0060005688/ref=sr_1_1?ie=UTF8&s=books&qid=1260207811&sr=1-1#noop%5B/url%5D,

but I've heard the author interviewed. It might have the answers you're lookin for.

Mattie

Gail,

That's why you're the exceptional DBA, or at least one of the judges. That's exactly it, almost all of our databases are still 2000, and this is one of...