Viewing 15 posts - 1 through 15 (of 16 total)
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. ...
November 19, 2020 at 2:55 pm
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...
November 3, 2020 at 4:38 pm
This was removed by the editor as SPAM
November 3, 2020 at 12:52 pm
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...
October 14, 2020 at 4:08 pm
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...
September 3, 2020 at 5:59 pm
I posted a reply and it was removed as spam. Please explain how my opinion was spam.
September 3, 2020 at 12:35 am
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...
September 1, 2020 at 7:27 pm
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...
August 26, 2020 at 7:11 pm
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?
June 29, 2020 at 2:59 pm
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...
June 29, 2020 at 1:50 pm
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...
August 22, 2019 at 12:40 pm
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...
August 22, 2019 at 12:31 pm
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...
August 19, 2019 at 8:04 pm
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...
August 19, 2019 at 12:24 am
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...
August 18, 2019 at 10:10 pm