-
A short myth to look at: subqueries in the SELECT clause
Read more: A short myth to look at: subqueries in the SELECT clauseThis past week, I was sick and so I didn’t hang around social media much. But as I got better, I found more and more of the types of posts that just scream “I don’t know what I am talking about” from the poster. This was a pretty easy topic for the day, so I…
-
The best laid plans of mice and bloggers
Read more: The best laid plans of mice and bloggersAs I write this post, my birth time has just passed. I am starting another rotation around the sun along with everyone reading this. It wasn’t my best birthday as I am still fighting a cold that started last weekend as I was traveling again after a vacation. It wasn’t terrible, as I spent it…
-
T-SQL Tuesday #200 – Concerning query traits
Read more: T-SQL Tuesday #200 – Concerning query traitsSo while I was on vacation last week, I saw Brent Ozar’s invitation post for the 200th episode of T-SQL Tuesday. And fittingly this was a T-SQL topic. No need to bring out any of my gushy feelings about past events or mistakes or whatever. Just “When I’m looking at a query, I bet it’s…
-
Being convincing
Read more: Being convincingI struggled to find a nice term for this blog (partially because I brought home a sinus infection from one of my recent vacation trips), but also because I didn’t want it to be overly insulting. Well, other than myself who knows that you have to say more than a short sentence that doesn’t so…
-
Do you disconnect on vacation?
Read more: Do you disconnect on vacation?First, let me set the level. I think most everyone disconnects to some extent when they take vacation/leave of some sort. Otherwise it isn’t leave. So you have said “I won’t be at work on some day and your goal is to not be tied down. Next, for sake of argument, I am going to…
-
An interesting concept: Splitting queries with OR for performance
Read more: An interesting concept: Splitting queries with OR for performanceIn a recent LinkedIn post, a poster had a novel idea. Say you have a query that has an OR condition. Usually the OR condition in question are related concepts (like this UserId or another one), but sometimes they are quite distinct (like ProductCost is in a range, and ProductColor is in a list of…
-
The myth and the truth of filtering early
Read more: The myth and the truth of filtering earlyAn interesting phenomena has been occurring in LinkedIn that I really find interesting. It is the very repeated half truth. It is a concept that is true enough in some ways, but also wrong enough to cause confusion in people who are just learning. Transferring my primary social media use to LinkedIn has been a…
-
Theory and Practice
Read more: Theory and PracticeI read this quote somewhere recently, though I cannot find it on the internet anymore. But I love this: The gap between theory and practice is not as wide in theory as it is in practice [anon]. I have spent a lot of my free time in the past 26 years writing/speaking about the subject…
-
The logical lifecycle of a query
Read more: The logical lifecycle of a queryThere have been a lot of posts on LinkedIn of late about the “logical execution order” of a query that all really miss some really big points. I was corrected myself in some terminology because I mistook the term “processing” to mean the same as “order” in these discussions when I was explaining why logical…
-
Scenic City Summit 2026 Roundup
Read more: Scenic City Summit 2026 RoundupThe conference has passed, and what a great couple of days it was. During the lead up to the conference, we had a few minor snafus, like some ticketing platform issues and near the conference, our website would throw up a delightful message: We’re having trouble connecting This was happening about half the time when…
Fediverse reactions
Hello,
I’m Louis
I have been at this database thing for a very long time, with no plans to stop.
