Definition of an upgrade: Take old bugs out, put new bugs in.

I can think of a few concept albums that I would love to see as films, such as Operation:Mindcrime and Clockwork Angels. Perhaps C.S. Lewis' Out of the Silent...

This gotcha happened to us recently where we used a subquery in a DELETE statement and ended up deleting every row in the table. Lesson learned: Use Aliases.

Jim Youmans-439383 (12/19/2013)

---

At my last job, we had a use it or lose it policy. If you did not use your two weeks, then you lost it. The...

I'm rather fortunate to have a job where taking time off is not a problem, though it's only during the slow part of the year (late spring, summer, early autumn)....

sayfrend (3/27/2008)

---

Executed : exec sp_helprotect 'dbo.profiler'

Result : "Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 291

There are no matching rows on which to report."

Conclusion : What is this ?

Note...

Steven.Howes (12/13/2013)

---

Other than that, I'm not a gadget person, but I would love a new turntable. One that plays at 33&1/3 consistently. Not the 25-40 range that I...

To be honest, my dream job would have little to do with programming and more to do with my true first love, music. Even though I would love to...

Good question with a not-so-obvious answer. I use computed columns all the time, but never though about having nulls in them.

Wow! Got it right just by picking the 4 I had actually heard of.

My guess was Single User because I was thinking read only would still be logging. I guess not.

When I moved back to NC, I found that I couldn't get my NC license because the name on my SSN card did not match my birth name. Had...

OCTom (10/24/2013)

---

Toreador (10/24/2013)

---

For me, a better answer is to subtract one from the first day of the next month, as this method will allow the same code to be run...

sestell1 (10/24/2013)

---

Toreador (10/24/2013)

---

For me, a better answer is to subtract one from the first day of the next month, as this method will allow the same code to be run...

Thank you Steve for this article. This is something I need to do but haven't done yet. I guess writing the first one is the most difficult.