Nice article on cursors.  I agree that cursors should be avoided when a simple set based operation can accomplish the task.  By that I mean use INSERT INTO/UPDATE...SELECT ... FROM. ...

Why don't the developers just lobby to use only JSON files.  They are a lot cheaper.  The developers can write the application to do what they usually ask the database...

If you are interested in returning all the values of Result and there are only two possible results, return Min(Result) and Max(Result).  If there are more than 2 possible Result...

Thanks, George.  Put it on my account.  On account I aint gonna pay. 😉  Or open an account on the  Bank of San Seriffe and we will let Don Knuth...

I posted a reply and it was removed as spam.  Please explain how my opinion was spam.

Marcus

Thanks for a excellent article explaining relationship types and how they are implemented in a databases using foreign and primary key constraints on tables.  I am old school and have...

It is my opinion that I was dismissed from a contract because I challenged the boss over a poorly designed database.  He used to be a developer/DBA on the project...

Good, gitmo!

I am not up on all the agile literature but is there any interest in creating the initial application emphasizing both the left and right prinicples equally?

Marcus

I have been programming since 1977, getting into the weeds with the Heathkit educational series on analog and digital technology including machine and assembler programming.  I have also programmed in...

I went back and re-read the original article to make sure my comments have not been off topic.  The title is provocative but missleading.  The opinion is really about using...

I agree that some developers do not understand natural keys.  I have had developers tell me that they can just use the surrogate key to get a specific row.  My...

Hi Nova.  I was loose with the words I chose.  Sorry.   On my last project, the one with no natural unique keys, the end users wanted to have the...

OH is actually an alfa surrogate for Ohio.  And SSN is a semi-arbitrary surrogate key that originally carried some geographic information but not so much any more.  Often businesses have...

I have climbed up on this soap box many times before and cannot resist this time.  I have been a database designer for Oracle and MS SQL Server for decades...