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...

When you mentioned over source control systems than Git, it reminded me at one of my early employers (can't remember which) we used to use MS Visual SourceSafe.  That...

IT DEPENDS !

Database mirroring is not dead yet! ( Such a shame Microsoft uses that terminology now in its cloud context ) It still works and in some cases...