I am certainly not complaining about anything 😉 And I am sorry if it appears that way.

In fact, I am...

Hugo Kornelis (9/22/2014)

---

Good question, mediocre explanation.

This has nothinng to do with the ISNULL being executed or not. The correct explanation would be that the SELECT assigns a value once for...

All the reasons stated above ring true to my ears!

I'm sitting in a small company as well, and we have planned to upgrade from 2005 to 2012 (not 2014!) for...

No, it's not. It's a math lesson!

The...

Well put, Simon

You have spoken my mind in every single Commandment!

rohitc 87397 (9/5/2014)

---

Andy, I think you just opened my eyes. I am one of those people who have always claimed that titles don't matter, and I never use it when...

Spot on: "Murphy's Law" is in my experience very close to being a Law of Nature, when it comes to the area of computer technology.

People who count on always traveling...

What's the compelling reason to use a subset of data? If it is no big deal to copy a recent backup into a test area, why not just do it?...

Currently, I work in a shop with full access to production data - and an environment where queries exceeding 5 secs are deliberate and exceptional (because I need a "quick"...

Mohit K. Gupta (11/4/2013)

---

When I wrote this article, I didn't take many things into consideration. However the primary reason for article was to provide normalization, which made it easier for...

One of the most prominent "errors" I see my fellow (and former) programmers do to our TSQL code base is: They don't care for - or don't understand - set-based...

Thank you, Steve, I like your approach 🙂

One thing is to get and keep a job, a career, money, fame, whatever. However, I always find the true improvements stemming from...

shivaram challa (10/29/2013)

---

Hi MMcPherson,

This will work more so becasue this statement will truncate the 10 and 11 to 1 (due to varchar(1)) and compare that against 1.

More accurate statement would...