To be honest, you're probably wasting your time doing traditional index maintenance.  Worse yet, you could actually be perpetuating fragmentation if you're using REORGANIZE.

With the thought that I named the...

If YOUR data center isn't "on the cloud", the On-Prem shouldn't be too different.  Normally, "on-prem" is another way of saying that the "data center" is not only owned by...

TBH... I'm deathly afraid of any changes or "improvements" that MS makes any more.  The huge slowdown that started with the new cardinality estimator in 2016 was the first big...

I concur with the error found by Jeff Williams.  I also concur with the OUTER APPLY method being faster.  With the correct index, it's actually twice as fast as the...

Since the author of that article hasn't answered the latest question there in over 4 years, why not just try it and see?  Then, you can answer poor Jose's question...

To be sure, that's not "SQL Server".  There's no such thing as SQL Server 20.2.  What you're seeing is SQL Server Management Studio, which is also known as "SSMS".  That's...

Thank you for the feedback!

To follow up on Eddie Wuerch's good post, it's an old but powerful bit of ancient code known as a CROSSTAB.  You can get a good introduction to them in...

I'm not a ninja at it but you could try it in a "Maintenance Plan".  To execute a proc, you would use an execute SQL block.  You could have the...

Here's another method.  I got this idea for Piet Linden's post above.  We could work on the dates as he suggested because your latest data has overlapping date ranges but...

Sure...

If we look at the original...

And there's the rub.  Please provide 5 to 10 rows of readily consumable data for use to operate...

Alan... you might want to explain what the bernieML.samd. stuff is.

There should be an additional lesson learned here... when doing modifications to rows,  start with BEGIN TRANSACTION and then run the UPDATE.  If the rowcount is right, then COMMIT else...

You can have a look at sys.dm_db_index_usage_stats() to see if there have been any reads or writes since the last time the SQL Server Service was started.

Once you've decided that...