Performance differences between IN and EXISTS
I often hear people wondering whether the EXISTS or the IN operator is better. Let's start by saying that the two operators behave differently when NULL values are involved (see this post).…
Read articleCategory 50 posts
Programming
Writing about Programming.
NOT IN vs. NOT EXISTS when NULL values are involved
NOT IN does not behave as you would expect when NULL values are involved. Suppose you have the following tables: CDFIELD DSFIELD 1 ALPHA 2 BETA TABLEA CDFIELD DSFIELD 1 GAMMA NULL DELTA…
Read articleFunny long jokes and aphorisms about programming (and programmers of course)
Here are some funny jokes and aphorisms about computer programmers and programming in general: A man is smoking a cigarette and blowing smoke rings into the air. His girlfriend becomes…
Read articleFunny short jokes and aphorisms about programming (and programmers of course)
Here are some funny jokes and aphorisms about computer programming and programmers in general: There are only 10 types of people in the world: Those who understand binary, and those who…
Read article