Jeff Moden (3/22/2011)

---

Brandie Tarvin (3/22/2011)

---

<groan> Why oh why do the same "bad" solutions keep popping up when there are tons and tons and tons of articles telling people why it's...

Interesting question.

I managed to get it wrong by forgetting that += was introduced in 2008, not 2005.

One comment though: depending on settings of ARITHABORT and ANSI WARNINGS, it is quite...

happycat59 (3/25/2011)

---

I believe that the data is actually stored on 3 disks...2 have the actual data and the 3rd has the exclusive OR of the other 2 disks. Using...

UMG Developer (3/25/2011)

---

happycat59 (3/25/2011)

---

Steve - whilst you may not have heard of checksum (Vs parity) in relation to RAID 5 , try searching google for "RAID 5 checksum". I...

rmechaber (3/22/2011)

---

A fascinating and scary exploration of how SQL Server doesn't always follow ANSI syntax for dates:

http://www.karaszi.com/SQLServer/info_datetime.asp.

A salient quote:

Warnings and common misconceptions

Let me say this again: you don't want to...

Toreador (3/24/2011)

---

Just because it's trivial doesn't mean it's not a bug -...

Good question. I found it easy because I've been through the pain of changing collations a couple of times (right to the point of rebuilding master to fix the...

Really good question. Thanks.

cengland0 (3/22/2011)

---

SanDroid (3/22/2011)

---

I was talking about when the pounds are converted to Kilos before calculating displacement, since Kilos is the way to go, the math is always done wrong.

What...

Ray K (3/22/2011)

---

Just bring your...

Interesting question, straightforward answer and explanation.

But maybe another possible cause of the problem is not listed: Installation of Windows 2003 Server SP2 wrecked your ability to run Korn shell...

I learned something so it can't be all bad.

But I don't like all the references to expensive textbooks instead of to BoL that I see in Apress sponsored questions.

A pretty poor question, an awful explanation, and poor references.

I assumed it was about SSAS 2005 (date 6 Sep 2007, sponsored by Apress who sponsored the 18 Sep 2005 I'd...

I suspect that in Service Broker routes point to services, so I don't like this question and answer - it's a bit questionable.

Good question. I learned something new.

I always knew that decimal and numeric arithmetic did some sort of crazy type forcing that increased rounding errors; but I had...