Jean-Sebastien Carle (10/28/2009)

---

Also, the choice between varbinary(4) (which should really be binary(4)) and int comes down to deciding between being able to natively bitmask IPs with subnet from within SQL...

Elliott W (10/28/2009)

---

I am not sure about this statement "I think this nicely illustrates that a little knowledge is a dangerous thing - it shows us what might happen when...

Thanks. ...

R. C. van Dijk (8/24/2009)

---

The approach that the customer is always right, is totally wrong. Make them think they are right whilst feeding them with your own ideas is the...

I haven't looked at SQL Server encryption, so maybe I'm getting things horribly wrong (maybe you can't do it right with SQL Server), but I can't understand why there should...

Well, I...

Sounds like some sort of strange magic to me. I can't imagine how...

nimdil (8/19/2009)

---

nicholastjh (8/19/2009)

---

Nice article. Very informative.

But at the final function where 128 is subtracted from the result of ParseName, before being multiplied by 16777216 (2^24), could potentially yield negative results,...

I knew what the answer would be, so I got it "right". But "right" has to be in quotes, because it is actually wrong for application screnarios where disk...

It's hard to understand why MS introduced this storage format - perhaps they hadn't yet decided to provide table compression in the next version when they did this (although one...

Kevin Gill (8/14/2009)

---

The main impact of this that I've come across is that if you have two variables and both are null, the only complete equality check with ANSI NULLS...

The BOL reference after the explanation doesn't help at all, as it doesn't refer the dump command. Anyway, even in SQL 2000 the dump command was deprecated, MS recommended...

Well, I know what is supposed to happen so I got my point. But anyone still using SQLServer 2000 should be warned about this - the behaviour is erratic,...

Jeff Moden (8/4/2009)

---

I can't get over how many people are talking about sp's like they're new or something. 🙂 I've been a long time advocate of using stored...

Interesting starting point (thanks, Steve) and some interesting comments.

I agree with most of what Tom DeMarco says, but two things I don't agree with: that his discovery that the obsession...