Hey Jeff,

Thanks for the lesson.

And this is very nice. I missed the option to do

WHERE city in ('Arizona','California','Hawaii')

Also, not entirely sure how this line works

SELECT ByCityFirstNameID = ROW_NUMBER() OVER...

BWAAAAA-HAAAAA-HAAAA!!!  See?  As predicted including the rubbish about how "identifiers can't be numeric". 😀

Yes...

To be sure, the "WITH" that you speak of is called a "CTE", which stands for "Common Table Expression".  In many cases, you can simply move such things to a...

To be sure, my rant on this subject isn't directed towards anyone in particular, especially the poor ol' developers (I used to be a front-end developer a long, long time...

p.s.  Since Joe Celko is one of my "followers" (and this site won't allow me to reject certain people as "followers" 🙁 ), if he shows up with his normal...

Man-o-Man, Carton!  Nice job on the DDL and test data.  It ran perfectly and made my life a whole lot easier to help.  Very well done.

Here's one fairly easy answer...

It may all come done to the interpretation, but this cycle seems perfectly relevant.

Do it: get the first draft implementation. I'm to often locked in meeting on how should...

Hi Jeff,

Thanks for the options provided. One thing wanted to know, will both methods will take of Transaction log reuse right? meaning, rather than log file growing out of...

the industry also has a track record of many improvements that are improvements. Hence my post. It's easy to be too negative or positive. I am striving for a...

It's a real shame that a lot of people writing software and user interfaces don't seem concerned with that balance.  And I have to disagree with you... the industry has...

So, you're saying that a Senior DBA doesn't need to know about Clustered Indexes or even how to get the current date and time in T-SQL?  Heh... I've seen what...

I mostly agree, Eric.  I DO ask the "What" question first, though.  The reason why is that most candidates are as nervous as a chicken wearing a pork chop necklace...

I don't think he's asking the wrong question. He's asking a very specific question, what are the things only a login in the sysadmin fixed server role can do. ...

I would normally agree but the industry has a huge track record of...

Requirement : We want to retain latest 1 year data(i.e. 2021) and delete other year's data by deleting 30 days worth data in each iteration. In other words, want...