Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag joe celko Rss

   Items 1 to 4 of 4   
 

SQL Style Habits: Attack of the Skeuomorphs

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.   Read more...
By Additional Articles 2015/07/24 | Source: SimpleTalk | Category: joe celko
Rating:  Rate this |   Briefcase | 3,873 reads

Getting rid of SQL Code

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.  Read more...
By Additional Articles 2009/09/03 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 5,601 reads

Celko's Summer SQL Stumpers: Prime numbers

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.  Read more...
By Joe Celko 2009/07/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,872 reads

Avoiding the EAV of Destruction

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.  Read more...
By Additional Articles 2009/07/02 | Source: SimpleTalk | Category: database design
Rating: (not yet rated)  Rate this |   Briefcase | 1,830 reads
   Items 1 to 4 of 4   
 
Tags
t-sql (2)    
cobol (1)    
database design (1)    
fortran i (1)    
sql puzzles (1)