daniel.freedman 80164 (9/4/2015)

---

I'd have them all as separate packages. You can have a new "Master" package which calls the others one by one, one advantage of this is that the...

Grant Fritchey (9/3/2015)

---

ZZartin (9/3/2015)

---

I've never said I think foreign keys are bad, all I've said is that I don't understand why some people consider them a must have. If...

I would love to upgrade from 2008 R2 to at least 2012. I've been granted that wish thus far, but have not made the transition yet.

Now with 2014, something that...

Steve Jones - SSC Editor (9/1/2015)

---

xsevensinzx (9/1/2015)

---

I'm not really seeing the connection between the first linked stories in the first paragraph.

A solution--which is what the doctor is aiming to apply--is...

I'm not really seeing the connection between the first linked stories in the first paragraph.

A solution--which is what the doctor is aiming to apply--is totally different than the benefit from...

Wouldn't this be database professional? Why are we all lobbed under DBA's! 😛

I'm always telling people I'm not a DBA dangit.

Eric M Russell (8/31/2015)

---

Orphan records can pose serious problem in an operational or OLTP database. However, they are less of an issue in a data warehouse. There is this thing...

rnunn (8/31/2015)

---

I agree.

In addition to eventual duplication, I also think transition to a data warehouse will be difficult at best, and the resulting information unreliable.

A world without foreign key relationships...

If you approach everything with the notion that nothing is perfect, that we all write bad code and we can always write better code. Then you will find a lot...

ZZartin (8/29/2015)

---

xsevensinzx (8/29/2015)

---

Ed Wagner (8/28/2015)

---

Scott, I agree with you that the point is to run a business. You raise a good point about perspective. It may be that...

Ed Wagner (8/29/2015)

---

xsevensinzx (8/29/2015)

---

Ed Wagner (8/28/2015)

---

Scott, I agree with you that the point is to run a business. You raise a good point about perspective. It may be...

Ed Wagner (8/28/2015)

---

Scott, I agree with you that the point is to run a business. You raise a good point about perspective. It may be that cutting off...

David.Poole (8/27/2015)

---

Hive and Pig both generate map reduce code under the hood. Where optimisation is required you can grab the output code and adjust it to your needs.

Hive has...

Here is a great list from a StackOverflow question that I quote a lot. I bolded the ones I think apply to SQL Server.

Made a change to code, realised it...

Stuart Davies (8/18/2015)

---

I was asked for my portfolio about ten years ago by a UK company - so was aware of it coming as it does for designers, photographers etc....