Robert Frasca (10/25/2010)

---

tfriedman71 (10/25/2010)

---

I agree with Quazibubbles post as well. The surrogate primary key needs to be paired with a unique key in order to maintain data integrity. ...

tfriedman71 (10/25/2010)

---

I agree with Quazibubbles post as well. The surrogate primary key needs to be paired with a unique key in order to maintain data integrity. This concept...

michael vessey (10/25/2010)

---

An interesting article, but there seems to be one aspect that has not been covered.

The article suggests that there is a slight overhead using a surrogate key (as...

As a VSB (Very small business 😉 who uses SQL Server, 20K is just out of reach. I am a sole proprietor, I pay my salary, have a home...

I routinely work with tables where the entire table is a PK, name and address and five other fields. these are just mailing lists, but HUGE - to me...

Gail,

Complete nubee here. What does "narrow" mean in the "considerations for selecting the clustering key". What would be useful is to show in the graphic what happens as...

Grasshopper,

I think you are right about "what you believe fulfilling what you believe".

Back in the 80s I really wanted to do Electrical Engineering, in fact micro processor (uP) design or...

Having a degree does not imply anything at all, and not having a degree does not imply anything at all.

In fact having a degree means exactly and only one thing,...

I have a high school diploma and an electronics technician training from the US Navy. Having no college diploma I have a somewhat bitter understanding of the importance of...

Charles Kincaid (10/11/2007)

---

But I have another customer with two separate networks. I have to VPN from home to office. Then VPN into Network One. Finally VPN from Network...

I am a consultant so of course I don't run into the resistance to remote work the way employees do. I recently moved my business to North Carolina and...

I do all of my work remotely since I moved to North Carolina but my clients are all over the US. I use TrueCrypt to set up mountable encrypted...