Tom_Sacramento (9/11/2013)

---

Hi Steve - Kinda of a dirty trick changing the question...

The question posed at the front page sets mychar to varchar(10) which would fail the batch insert so 0...

L' Eomot Inversé (9/5/2013)

---

This question is somewhat confused and the answer is wrong.

It says the files "not be removed immediately" and asks how to force this garbage collection...

raulggonzalez (9/11/2013)

---

Steve Jones - SSC Editor (9/11/2013)

---

My apologies for the error. the question was tested, but as I'm sure many of you have done, I made a change in production,...

Richard Warr (9/11/2013)

---

In amongst all of the anguish over what the correct answer is we've missed the main issue here. It appears that Steve is a fan of Steppenwolf (either...

simon.crick (9/11/2013)

---

I agree 100% with the idea of a probationary period.

However... you still have to decide which candidate to hire for the probationary period, and it is still 6 months...

charles.jacobus-765275 (9/11/2013)

---

I still don't see how this directly (or just) relates to Microsoft. "They [Microsoft] have too much incentive to cheat." I disagree. I would be interested in knowing how...

chrisn-585491 (9/11/2013)

---

Steve mentioned self publication. There's a large number of people attempting to "game" that too. There's a lot of blog postings out there that are cribbed 99 percent from...

simon.crick (9/11/2013)

---

Why not base your decision on the candidate's academic qualifications?

College and university exams are far more rigorous and comprehensive than any interview tests can ever be.

Choose a candidate with...

True, but the same is true for any measure (MD, JD, CPA, PE, etc.)

...

If a DBA does not know the syntax...

My apologies for the error. the question was tested, but as I'm sure many of you have done, I made a change in production, altering the last name because I...

I wish I could be in Orlando, or KC.

I'll be at SQL Sat San Diego, Denver, and DevConnections.

Use htis: http://sqlfool.com/2011/06/index-defrag-script-v4-1/ in place of the maintenance plan index rebuild. It's intelligent and works better.

charles.jacobus-765275 (9/10/2013)

---

As someone with a number of certifications (some for SQL Server) and a former hiring manager, I have to respectfully disagree. In my view, certifications represent a broader measure...

Worth mentioning, but not necessary. That's not always a possibility.

dean.giberson 64357 (9/9/2013)

---

Steve: I think you are actually agreeing with me in that cancer patients (your example) fall into exactly what I was talking about. Cancer patients can...