Joe Celko


External Article

Arrays in SQL that Avoid Repeated Groups

It is certainly possible to fake an Array in SQL, but there are only a few occasions when it would be the best design. Most often, the wish for an array in SQL is a sign of a forlorn struggle against poorly-normalised data. One of the worst sins against Codd is the repeating group, as Joe Celko explains.

2011-07-20

3,438 reads

External Article

Improving Comparison Operators and Window Functions

It is dangerous to assume that your data is sound. SQL already has intrinsic ways to cope with missing, or unknown data in its comparison predicate operators, or Theta operators. Can SQL be more effective in the way it deals with data quality? Joe Celko describes how the SQL Standard could soon evolve to deal with data in ways that allow aggregation and windowing in cases where the data quality is less than perfect.

2011-04-01

6,632 reads

External Article

The DIS-Information Principle: A Splitting Headache

You can easily re-factor bad DML code, but if a database design is wrong, you can do little to rescue the problem, even with expert queries. So what constitutes 'wrong RDBMS design? What are these errors that continually crop up? How can you recognise them and fix them? Joe embarks on a new series of articles by identifying a series of bad practices based on the habit of 'splitting' that which shouldn't be split.

2010-09-08

2,767 reads

SQLServerCentral Article

Celko's SQL Stumper: The Class Scheduling Problem

What can we use in SQL instead of E. F. Codd's T theta operators for best-fit? Joe Celko returns with another puzzle that isn't new, in fact it already features “Swedish”, “Croatian” and “Colombian” solutions in chapter 17 of Joe's 'SQL for Smarties' book. These were all written before CTEs or the new WINDOW functions. Is there now a better solution? Was there one even then? We leave it to the readers to provide the answer!

4 (3)

You rated this post out of 5. Change rating

2010-01-25

1,682 reads

SQLServerCentral Article

Celko's SQL Stumper: The Data Warehouse Problem

Joe Celko comes back with a puzzle that isn't new, but one where the answer he originally gave now seems archaic: It is a deceptively simple problem, but is it true that the new features of SQL have simplified the solution? We leave it to the readers to provide the answer!

3.56 (9)

You rated this post out of 5. Change rating

2009-09-28

3,505 reads

Blogs

Using OneLake for Excel Files in Microsoft Fabric

By

Hey data friends! This blog is to discuss an edge case I’ve run into...

Another AI Faux Pax

By

I was experimenting with a local model (article) and as a part of this,...

Monday Monitor Tips: Using the PowerShell API

By

Redgate Monitor has grown tremendously from its early days and I find many customers...

Read the latest Blogs

Forums

Transpose sql table rows into columns

By SQL Bee

I want to transpose sql table rows to columns. I have written a query...

Generate number fields

By dbayliss1978

Hi all, I hope someone can help with advice. What would be the best...

Sparse Column Defaults

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Sparse Column Defaults

Visit the forum

Question of the Day

Sparse Column Defaults

What are the restrictions for defaults on columns declared as sparse?

See possible answers