-
T-SQL Tuesday #195 – How has your code aged
Read more: T-SQL Tuesday #195 – How has your code agedMany thanks to Pat Wright for this question that makes us all think about the trail of code we have left behind us during our years as programmers/admin/data analysts. Hmm, that may have come off as sarcasm, but considering I hosted last month and asked people to talk about mistakes they have made, I have…
-
Generating a set of sequential numbers, part 2
Read more: Generating a set of sequential numbers, part 2When I wrote the blog from last week (Performance test of generating a set of sequential numbers), I was mostly wanting to see how well I could do this using a recursive CTE. I wondered how terribly they might be. Turns out, they are terrible compared to other methods, but they also aren’t nearly as…
-
This post is not only about SELECT *
Read more: This post is not only about SELECT *I was about to walk out the door to take a flight, when my phone rang. Our major software system we had just released last week was returning weird data. FirstName and LastName was being reversed. I missed my flight because someone wrote SELECT * instead of SELECT FirstName, LastName and a table structure was…
-
Performance test of generating a set of sequential numbers
Read more: Performance test of generating a set of sequential numbersI have read so much lately about how bad it is to use a recursive CTE to do… well pretty much anything. It came up in a discussion about creating sequential number, and not in a positive sort of way. I wrote about recursive CTEs when they were first added to SQL Server, and have…
-
T-SQL Tuesday #194 – Roundup – Learning from Mistakes
Read more: T-SQL Tuesday #194 – Roundup – Learning from MistakesAs I sit here, preparing to write my roundup post, I have not read anyone else’s post yet. I thought it would be good to introduce the idea first, recap to the other posts, then mine. I won’t share any detail of the mistake I shared, but I do want to mention something I included…
-
T-SQL Tuesday #194 – Learning from our mistakes
Read more: T-SQL Tuesday #194 – Learning from our mistakesAs the host, I don’t actually have to answer this one, and I won’t lie, I considered it. This might just have been too much to ask of anyone, much less the one who set the whole question up. I am answering because this could be a really powerful thing to let other people of…
-
You don’t need to know anything because AI exists?
Read more: You don’t need to know anything because AI exists?Oh my, this is the least awesome thing I have seen anyone say about AI and it is a very common thing lately. It seems to be one of the latest sound bite/click bait/garbage post basis to get on my nerves. This LinkedIn post from Scott Hanselman was the inspiration to write this post (as…
-
How indexes are used with COUNT in SQL Server
Read more: How indexes are used with COUNT in SQL ServerA few weeks ago, there was a LinkedIn post (I can’t find it anymore) that covered something about how indexes were used by COUNT in SQL. I think it may have been based on SQL Server, but I am not sure (it is rare that one of the SQL posts on LinkedIn mentions a platform).…
-
T-SQL Tuesday #194 Invitation – Learning from mistakes
Read more: T-SQL Tuesday #194 Invitation – Learning from mistakesThis is my second time hosting T-SQL Tuesday and I am excited to do it again. With this being the second week of 2026 it is most likely that time of year that you have already forgotten those New Year’s Resolutions you made a few weeks ago. With this first T-SQL Tuesday of the year,…
Hello,
I’m Louis
I have been at this database thing for a very long time, with no plans to stop.
