Tag Archives: T-SQL

Finding and Updating Duplicate IDs: #SQLNewBlogger

Posted on March 18, 2026 by way0utwest

Finding duplicates was an interview question for me years ago, and I’ve never forgotten it. Recently I got asked how to easily do this and delete them, so I decided to write a couple of posts on the topic. This … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

Identity Columns Can’t Be Updated: #SQLNewBlogger

Posted on February 25, 2026 by way0utwest

I’m not sure I knew identity column values could not be updated. I ran into this while trying to solve a problem recently and had to check the error I was getting. This post shows what happened. Another post for … Continue reading →

Posted in Blog | Tagged , , | 4 Comments

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