Ben,

Your solution using aggregate functions is similar to the use of characteristic functions in SQL Server to achieve pivot and unpivot operations in a single SELECT. This was documented in...

Obviously aimed at an audience with some technical knowledge, but it does not speak down to the reader. I think the query boxes that allow you to test your understanding...

I've been in bullpens and 5 foot high cubes. I prefer the cubes. But i do have to say there is something for working in the computer room. Granted, at...

Accountability is a huge factor in being granted the privilege. And except for outsourcing, it IS a privilege.

Having the ability also makes it possible for some of to continue working...

I was doing mainframe FOCUS development when I first met SQL. We were a big red N shop and the W word was not tolerated well. An outcast from another...

Agreed, the wording was a little. off. Then again, from the list, those 3 options were definitely the oldest and were introduced to diagnose problems or mirror underlying functionality MANY...

Was it then impossible for the OSx user to resort the content and find a better price? If so I would agree about the questionable ethics. On the other hand,...

It wasn't software, specifically, that got me hooked. I was an auto mechanic in the late 70's/early 80's. I attended a Delco-Remy seminar on the first electronically controlled carburetors where...

Andrew Diniz (2/19/2013)

---

Carlo Romagnano (2/19/2013)

---

The update may fails with error, if the default collation is case sensitive.

UPDATE GenderUpdate

SET Gender = CASE WHEN GENDER = 'M' then 'F' ELSE 'M'...

I usually end up doing the technical dirty work in interviews, asking the probing questions to figure out if they candidate actually knows SQL Server or has just read something...

Since 5 of the 6 are correct, any combination of 4 of the 5 correct answers should have scored the point. Will those of us penalized for choosing correct answers...

I've worked with people who got their certifications solely from a book. As Sue pointed out they could not deal with a real problem when confronted. As in, they couldn't...

Looking forward to this one too. I just got SQL Server 2012 Query Performance Tuning by Grant from Apress. Looks like another classic

ACTUAL execution plan agrees with BOL. The answer explanation clearly disagrees with both. If we assume that the correct answer would be the one the SQL Server returns, the answer...

I'd agree that the intent was more important than the answer. Well done.