Plagiarism cannot be tolerated but we all get ideas from examples. The idea of the query below came from the OTN Forum SQL and PL/SQL by Chris227. The...

Both of these examples depict DSS type operations. Rather then denormalize a live database I would prefer to created a data warehouse where denormalization is the norm. I...

Wow, never had a problem! Are you a one man shop? How big is you largest database? How much data? What tool do you use to...

Thanks for the reference. Now I understand but I have rarely seen this pattern. As a DBA with 20 years experience I want as much data integrity in...

This article makes it sound like you have to choose between a natural key with a unique index or a surrogate key with a unique index. Every time I...