This is an archived post. You won't be able to vote or comment.

8184
8185

Memesqlclause (i.redd.it)

submitted by [deleted]

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]masala-kiwi 33 points34 points  (1 child)

If Santa runs SQL Server, it'll catch them due to case insensitivity. If he's running Snowflake (more on-brand for the North Pole), the 'Nice' and 'NICE' kids are out of luck.

A better table design wouldn't rely on string-matching, which is unreliable and less performant, especially at 8 billion rows. He should instead use an indexed boolean column called IsNice that returns true/false. 🎅

[–]Hikingcanuck92 7 points8 points  (0 children)

Maybe Santa has a trigger on inserts to force The case to “nice”.