I didn't have to run the code to know the answer, but, what if I did? It still would be a learning experience which is the point of the QotD....

Who has time to read? 😛 Reading the results of a meeting can be just as wasteful. Meeting in person can help you pick up subtleties that don't end up...

GabyYYZ (4/23/2010)

---

My brother-in-law recommended I watch it one night when I was visiting my sister and he in Amsterdam (this past winter...

Steve Jones - Editor (4/22/2010)

---

I think this was worded a little poorly, and I didn't catch the insert issue. I ran the code on 2008, it worked, I let the...

Spring cleaning systems is rarely done because you're always on to the next new project. Your own in-house projects aren't seen as money makers, so, they're always on the back...

Reminds me of the movie Office Space. 😀

Kingston Dhasian (4/22/2010)

---

Nice question. Not many know that even a TRUNCATE can be rolled back.

Some people as mentioned might get tricked by the INSERT statement and may choose the wrong...

sknox (4/20/2010)

---

Hugo Kornelis (4/20/2010)

---

Tom Brown (4/20/2010)

---

A Good question. I learned something from this.

I've used IDENTITY for ages, assuming its both duplicate-proof and automatically indexed.

I'm glad to...

Thanks Matt & Jason. That's what we're doing here, too. We're not loading up to the max, either. I think that's been a stable I.T principal for a very long...

The "true" part gets me. What does THAT mean? I have never seen a definition of a "true" DBA nor met anyone who said they were. I have met a...

Lightly virtualized? I thought a server was either virtualized or not?

I've been at companies that put on picnics and such. Bonuses tend to be expected after awhile. Instead getting a bonus for a job done well, it gets to be...

Won't you just need...

This got me learning about the model database. That's a good thing.

Thanks.

I think some standards should exist. I don't necessarily want government involved, but, at some level to help identify what a person can do at a basic level.

I've known people...