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 3 of 3   

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,517 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,860 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,752 reads
   Items 1 to 3 of 3   
t-sql (2)    
database design (1)    
sql puzzles (1)