GilaMonster (6/23/2014)

---

andrew gothard (6/23/2014)

---

The...

Gary Varga (6/12/2014)

---

My point is that, bearing in mind the editorial, the whole way of thinking is as flawed as the value of the number of legs as described in...

simon.crick (6/12/2014)

---

Tension arise when Developer and DBA roles/responsibilities are not properly separated.

It sounds simple because it is. Problems only arise when people forget the basic principles of software engineering, i.e....

The concept's not nonsense...

crmitchell (6/20/2014)

---

Ed Wagner (6/20/2014)

---

Honestly, I was a little surprised that you could create a type named "number" so I just had to try it. It worked, so I...

SQLRNNR (6/20/2014)

---

andrew gothard (6/20/2014)

---

Ed Wagner (6/19/2014)

---

andrew gothard (6/19/2014)

---

below86 (6/18/2014)

---

andrew gothard (6/18/2014)

---

below86 (6/16/2014)

---

andrew gothard (6/15/2014)

---

Koen Verbeeck (6/14/2014)

---

Badly phrased, sorry. In a column that should be a date, it's plain stupid...

Ed Wagner (6/20/2014)

---

andrew gothard (6/20/2014)

---

Ed Wagner (6/19/2014)

---

andrew gothard (6/19/2014)

---

below86 (6/18/2014)

---

andrew gothard (6/18/2014)

---

below86 (6/16/2014)

---

andrew gothard (6/15/2014)

---

Koen Verbeeck (6/14/2014)

---

Badly phrased, sorry. In a column that should be a date, it's plain...

Ed Wagner (6/19/2014)

---

andrew gothard (6/19/2014)

---

below86 (6/18/2014)

---

andrew gothard (6/18/2014)

---

below86 (6/16/2014)

---

andrew gothard (6/15/2014)

---

Koen Verbeeck (6/14/2014)

---

Badly phrased, sorry. In a column that should be a date, it's plain stupid (if you do...

below86 (6/18/2014)

---

andrew gothard (6/18/2014)

---

below86 (6/16/2014)

---

andrew gothard (6/15/2014)

---

Koen Verbeeck (6/14/2014)

---

Badly phrased, sorry. In a column that should be a date, it's plain stupid (if you do that in your Order...

below86 (6/16/2014)

---

andrew gothard (6/15/2014)

---

Koen Verbeeck (6/14/2014)

---

Badly phrased, sorry. In a column that should be a date, it's plain stupid (if you do that in your Order Taken timestamp column...

Koen Verbeeck (6/14/2014)

---

andrew gothard (6/13/2014)

---

" store the dates as integers, like 20140612, and then join to a 'Date' table with this 'key' to get a real date field" - this...

Koen Verbeeck (6/14/2014)

Typically you break a datetime into a date part and a time part and store it in two dimensions.

This allows you to solve analytical questions on the date...

Evil Kraig F (6/13/2014)

---

Offhand, even in my warehouses, I never really saw a significant value in storing the date as a four byte int instead of the 8 byte datetime....

Koen Verbeeck (6/13/2014)

People come up with the nonsense because other people - like Kimball - tell them to.

Kimball advocates that every surrogate key should be a meaninglessinteger (which is a...

Andrew Kernodle (6/12/2014)

---

Yep, we're in the same boat as far as compatibility and versions go. We're technically not supposed to be using 2008R2 by the vendor's contract (2008 is...