I indicated that the need for a cursor is rare but you need to be willing to use them.  If you need to update 6 tables based on the data...

9. How many loops were used to determine duration and is it clock or cpu time.

10. Was the load on the system constant like in a stand alone database on...

I believe that the fast forward cursor of SQL Server is a great tool to use if, and only if, multiple actions need to be taken on each record returned. ...

I am sorry for the late response and don't know if you are still looking for an example.  By definition, a critical part of conceptual modeling is identifying the unique...

Since you are illustrating your process using a physical database, I think it would be instructive to include primary and foreign keys on your normalized tables to enforce your normalization. ...

Great article, Sucharita.  The explanation of these 4 normal forms is clear and concise.  As Scott said, normal forms are a conceptual construct but I believe this analysis is useful...

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...