dbursey (5/15/2013)

---

Stefan Krzywicki (5/14/2013)

---

The Dixie Flatline (5/14/2013)

---

Stefan Krzywicki (5/14/2013)

---

The Dixie Flatline (5/14/2013)

---

Does that mean you're not a fun...

PompeyTID (5/8/2013)

---

If you recruit someone on their aptitude (capacity) to learn, keeness, motivation, who is respectful of others, consciencious, honest, (note NO technical skills), you can then provide the framework...

Ming

A nice way of showing how a spelling error can have bizarre results as a consequence of a piece of what (despite Hugo's explanation, which is nice and clear) is...

Mighty (5/8/2013)

---

It also might be because it is still early here, but what is the point exactly?

. What is it exactly why it works? The...

It's a nice question, but the explanation is a bit light - no indication of why statement 6 fails. I know people will see the answer in BOL...

I suspect the mix of people skills and technical skills required for a DBA can vary greatly, although generally I would expect the people skill component to become more important...

tmac25 (5/3/2013)

---

I think you'd use something like this?

SELECT users.employeeid, skill.skillid

FROM dbo.users_hierarchy as 'users'

INNER JOIN dbo.old_skills as skill

ON skill.id = users.employeeid

WHERE NOT EXISTS (SELECT...

GeorgeCopeland (5/3/2013)

---

Oh good grief, just have the issuing authority PKI sign the fingerprint image files and set up an authentication server with good failover characteristics. Use open source software so...

The natural thing to do is calculate the age in years in a cte, then calculate teh age in months for cases where the age in years is 0. ...

Nice question.

There are two (harmless) oddities, though:

I didn't (and still don't) know what the question is actually supposed to mean. "without changing the identity property of the column" can't really...

In this case that's the right order to tackle them.

Without different viewpoints one can never learn. I'd prefer to try to continue the...

If you want a relational solution, a primary key is essential. If a non-relational solution will do, it isn't. Of course you have to care about whether a...

ChrisM@Work (5/3/2013)

---

Lynn Pettis (5/2/2013)

---

Okay, I have to ask without pointing to anything specific, do any of you think I have been harassing any of the OP's recently rather than helping...

Evil Kraig F (5/2/2013)

---

Well, true enough. 😀 However, its purpose on my wall is not as a reference, but to deter some overly optimistic folks about just how important...