Tag Archives: T-SQL

RANK() vs DENSE_RANK(): #SQLNewBlogger

Posted on February 18, 2026 by way0utwest

I haven’t done one of these in awhile, but I saw an article recently about this and decided to explain it to myself, but in a slightly different way. You’ll see how I checked on RANK() vs DENSE_RANK() below. Another … Continue reading →

Posted in Blog | Tagged , , , | Leave a comment

Aging Code for T-SQL Tuesday #195

Posted on February 10, 2026 by way0utwest

It’s that time of the month again, with T-SQL Tuesday coming along. I managed to not forget about this and checked with the host. He had an issue, but fortunately I got a friend to step up. This month Pat … Continue reading →

Posted in Blog | Tagged , | 1 Comment

Learning from Mistakes: T-SQL Tuesday #194

Posted on January 20, 2026 by way0utwest

We’re a week late, once again my fault. I was still coming out of the holidays and forgot to check on my host. Luckily, Louis Davidson (who did have Feb) agreed to go early. He has a nice invite, and … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Refactoring SQL Code

Posted on December 12, 2025 by way0utwest

One of the things I see software developers often talking about is how they refactor code. As they touch a class, method, etc., they may take the time to refactor the code to make it cleaner, perform better, or just … Continue reading →

Posted in Editorial | Tagged | 1 Comment