Brent Ozar has a new animation:
Let’s use the Users table from the Stack Overflow database, and let’s pretend that the Users.Location column is stored as JSON rather than letting users type in whatever they want. Let’s pretend we make them pick their Country, Province, and City. Then, let’s use one of my Database Animations to illustrate the pain of querying it without the JSON index, and then the cake-y-ness of the added index:
Brent also has an issue with the phrase “have your cake and eat it too” but I think it’s a proper phrasing that relies on a temporal understanding and pushing a past-tense verb into the present. The idea is that you cannot simultaneously have eaten your cake, while also maintaining it for later. I can understand Brent thinking the common phrase is a temporal slight of hand, but that one never bothered me.
The one that has bothered me for decades is “the proof is in the pudding.” The proper aphorism is “the proof of the pudding is in the eating.” The latter actually makes sense, whereas the former is an abbreviation that changes the meaning so much enough to remove most of its value as a folksy saying.