Here's an introduction to what you need to do...

https://www.sqlservercentral.com/articles/finding-%e2%80%9cactive%e2%80%9d-rows-for-the-previous-month-sql-spackle-1

If you need more detailed help, we'll need some "Readily Consumable Data".  Please see the first article in my signature line below...

Lordy... I can't believe they didn't use a cursor or while loop, according to another article that appeared today.

I totally agree with Drew's post.  You haven't used an example that even comes close to justifying the use of such RBAR.  This could cause folks, especially beginners, to make...

I'm of the "strong opinions, loosely held" view. I want to stick with things until I see something new working better. Meaning not only is it performing/working/saving/etc. better, but...

Certainly learning your existing tools well is important. However, I think you should also be learning new skills and judging when they are useful. That means lots of tests.

For...

Doing a "bump" so people can see page 2.

Certainly learning your existing tools well is important. However, I think you should also be learning new skills and judging when they are useful. That means lots of tests.

For...

From the Article:

---

That's a tough process to implement, and one many companies don't spend the time doing, but for those that do, they end up deploying many...

Great article and links, Steve.  Thank you.

Fishing has been perfected.  There are no new ways to entice fish to take your bait.

https://getpocket.com/explore/item/timeless-fishing-skills

An old-fashioned cedar plug is a simple but...

Good idea for an article but there are a few issues... here's one of them...

Here's your "Disable the Indexes" example...

-- Disable indexes
ALTER INDEX ALL ON YourTable DISABLE
--...

First of all, the warning was telling you that you have columns that you're doing aggregates like SUM() and COUNT() on contain some NULL values.  Are you sure those columns...

Thanks for the...

Bit late to the party on this one (only just seen the article).

Instead of using FOR XML PATH, there's a new function (I've only just started using it on...

I might get a few eye-rolls from you, in return, because I'm going to tell you to stop doing generic, catch-all, supposed "Best Practice" index maintenance.  It's all causing more...

You've certainly impressed us there.