Joe Celko

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

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

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,625 reads

Blogs

3D Printing Ear Savers Aug 6th 2020

By

I have now printed over 20,000 ear savers. I hit 20k printed yesterday on...

Creating a SQL Clone Agent and a First Image

By

In a previous post, I set up the SQL Clone server. This is really...

Availability Group issues fixed with Alerts

By

Learn how to use the SQL Server Agent Alerting system to capture Availability Group...

Read the latest Blogs

Forums

how to find why the stored procedure took time to execute

By saum70

Hi, This is one of the incident at our clients side and does not...

Using Pivot in SQL

By Mysterio

I am trying to create a query from this table: above is my table,...

Query optimization

By curious_sqldba

Hello..i am running into an issue where below query is requesting large amount of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

BDC Storage

See possible answers