Viewing 15 posts - 1 through 15 (of 24 total)
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...
February 2, 2022 at 3:38 pm
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...
January 29, 2022 at 10:27 pm
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...
October 19, 2021 at 8:19 pm
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...
October 19, 2021 at 7:05 pm
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. ...
October 19, 2021 at 7:00 pm
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...
May 31, 2021 at 3:19 am
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. ...
February 22, 2021 at 5:28 pm
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...
February 9, 2021 at 4:15 pm
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