Sorry, I thought that was kind of cheesy.

Primary keys are a must. Also, do not create and leave a temporary object (especially a table or stored procedure) in my production database.

I agree with indexes, however don't create an index just to have an index. Plan out your indexes and maintain them. I inherited a database that seems to have no...

If this is the question "have list off all employees with the employees with DateOfLeaving coming last and all others sorted ascending order of date of leaving, Name sorted in...

My frustration comes when the developers rush a project out the door so they can say it went on time and then move on to the next project. It doesn't...

I have a one week vacation planned in August, and I won't be taking a cell phone along for the ride. I've worked enough nights and weekends this year that...

How do you talk you company to actually spending some money to send someone to a conference. I'm at my 3rd company in the last 8 years and none of...

I see the DBA job market as being great right now. I have recruiters calling all the time. I'm not looking to change jobs right now since I just started...

If you have quality you can get some consistency with it. I have been on projects where the code was very consistent, but unfortunately it was consistently bad code. I...

I see lots of problems, but does anyone have a reasonable solution? If our system crashed I am afraid of trying to restore the keys as we have no DR...

Gives me more stuff to figure out, thanks for the question.

I also used a simple case statement in the where clause. Although longer than the given answer, I prefer this method.

Like the other posts states, I also found 2 correct answers. Good thing I guessed correct.

I also ran all three queries with my birthdate, and the first and third returned the wrong answer. However, the second one was correct.

I spent one year at a Junior College in St. George, Utah. I would love to move back there to work. Small town with plenty of outdoor activities. I then...