Joe Celko


SQLServerCentral Article

Mathematicians and SQL

Georg Ferdinand Ludwig Philipp Cantor is considered the creator of set theory, and his theories are the basis for the naïve set theory you learned in school. But there are lots of other mathematicians you should know, such as Hilbert, Frege, Russell, Zermelo and Dedekind. They made a lot of contributions, too. Hilbert Hilbert is […]

4.33 (3)

2021-01-19

5,324 reads

SQLServerCentral Article

Data Element Names and Scoping Rules in SQL

How you name data elements in databases and applications programs has often been a matter of personal taste. Decades ago, when I worked for state government, there is a COBOL programmer who would pick a theme for his programs. The paragraphs and variables would be named based on the current theme. One of his programs […]

4.2 (5)

2021-01-11

1,662 reads

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)

2010-01-25

1,650 reads

Blogs

Daily Coping 21 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using dbachecks for CIS Security Checks

By

Well back at the end of 2019 I finished writing most of the checks...

How to tell if Change Data Capture (CDC) is working as expected

By

I’m not sure how many of you use Change Data Capture (CDC) on your...

Read the latest Blogs

Forums

Can secondary data file (.ndf) be created by default during sql installation?

By olegserdia

Primary data file, sitting on its own drive, has two files: .mdf and .ndf....

Extended Events stop writing to Ring Buffer in 10 minutes.

By Vladimir Isaev

It hardly goes over 1000 collected rows, and just stops further logging without any...

left join causing results to be multiplied

By profoundhypnotic

Hello, Hello, the query below is giving me some trouble. the results of the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers