Although we like to think that our programming techniques are progressive and in tune with the bleeding edge of software development practices, too often they are directly influenced by restrictions faced when computers first became mainstream in the post-war decades. In this article Joe Celko looks at the history of mainframes, FORTRAN I and COBOL.
2015-07-24
5,006 reads
Joe becomes intrigued by the way that experts make errors in any area of technology, and suggests that the problem is more that of mindsets than lack of knowledge. He illustrates the point with SQL Development by means of the "Britney Spears, Automobiles and Squids" table, and the tangled Stored procedure, and shows ways of getting rid of both procedural and non-procedural code by adopting a different programming mindset.
2009-09-03
5,983 reads
Our first Stumper sees Joe Celko providing a conundrum with a prize for anyone who can come up with a better solution than he can.
2009-07-27
3,127 reads
A forum posting, from someone who wanted a better solution to the common problem of handling global settings in a database, leads Joe Celko into a fascinating discussion of the ramifications of the various solutions.
2009-07-02
2,239 reads
check out : The Curse and Blessings of Dynamic SQL http://www.sommarskog.se/dynamic_sql.html
2004-07-29
If I understand you correctly, you are looking to create the same table for many users but name it differently for each user. If so, prefix the table with the users login name on the server(SYSTEM_USER). That way you will have unique table names created and be able to trace them back to the user.
2004-07-29
You've probably got a record in table XXX with a value in the ATC_LVL_4_CD column that's not in the RDM_ATC_LVL_4_LKUP.ATC_LVL_4_CD column. use this query to find out if this is true: select xxx.* from xxx left outer join RDM_ATC_LVL_4_LKUP on xxx.ATC_LVL_4_CD = RDM_ATC_LVL_4_LKUP.ATC_LVL_4_CD where RDM_ATC_LVL_4_LKUP.ATC_LVL_4_CD is null This will identify any records in the table […]
2003-06-24
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-23
Thank you for your help. Please forgive me for asking another ? (I'm a beginner) This is going to work, however in my pass-through query in access I want to say Exec UpdateInfo @EmpID = '" & field name & "' Because the field value will constantly change. My syntax is not correct for my […]
2003-06-19
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers