As someone who has been around too long, I know the purpose of the semi-colon.  It is to define the end of a statement.  It is possible to put several...

Examples of CTE's with semicolons has always bothered me.  I started out in Oracle and the semi-colon is required and it only took about a year to finally include it...

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