I find that occasionally reading a newspaper or book is like CDs or vinyl albums. An immersive experience in my hands. Nothing digital that disappears when a screen times...

Ah, that's cool. Thanks

I always clean-up as I go, this way I do it when I am working on it knowing that I will not have a chance later on. It is...

Steve, you touched a live wire on this one with me.  In my humble opinion ( and you all know how humble I am ), if you don't do...

I'll admit that I am a culprit.  The dev instance looks like the SQL version of a condemned building.  Even PROD can be cleaned up a bit.

A decent project...

Another good reason to clear out unused code is when you have a column that is used to filter results and you find that it can contain a new...

People like Brent who say "don't clean up old code" apparently don't have much experience with 40-50 year old codebases that are still mission critical for more than 18...

Ah, that's good. I think.

Running that script for me shows no rights for dbo.

Do you have a screenshot? Wondering what you've got here.

I suspect logging in with the DAC might make this possible, but haven't tried. Curious what your system looks like. Can...

Thanks, I think that a lot of DevOps started out as let's be partners, but the automation overshadowed things and too many people don't act as partners with their clients.

Story of Murray's career.

I am getting killed on WRs, no one showing up or hurt. Amazed. I got 60 pts.

Thanks, interesting approach. I didn't think about adding the LAGs, which makes sense.

I certainly didn't think about NULLs in the balance. It wasn't part of the original spec, but you're...

Same....

I'd agree with this. VB is really...

If you are designing a new object with DML triggers, especially nested or recursive enabled triggers, then you should take a step back and consider if there is a...