-
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,…
-
I am not a guru, and neither are you (probably)
Read more: I am not a guru, and neither are you (probably)I don’t want all my output on this blog to be old grumpy guy ranting about the state of the world. But I do feel like some of them need to be that way. Because there are a few things that really drive me nuts with the state of writing and social media. Lots of…
-
Looking forward at 2026
Read more: Looking forward at 2026Today is my third annual brainstorm day. So far, all three have taken place at the EPCOT theme park. My wife has spoken at a conference here those past few years, and so close to the holidays, I kind of needed a break day that first year and so many he tradition was born. Louis…
-
That’s a wrap on 2025
Read more: That’s a wrap on 2025Weird, freaky year for me. I almost just left it at that, but I realized it might make me feel better about things to add some stats. I did not include the number of views/viewers/etc because I want to maintain the illusion of not caring for such things. I do care, but I also don’t…
Hello,
I’m Louis
I have been at this database thing for a long long time, with no plans to stop.
This is my blog site, companion to drsql.org
Drsql.link 