You've posted delimited data.  Take it to the next step and post it as readily consumable data and you might get better answers because more people will give it a...

Just in case you need to fight off the folks that still think that regular index maintenance based on logical fragmentation is a good idea, Microsoft finally "got the word"...

Then the derivative code from SwePeso's post will correctly return the total number of decimal hours for you.  You only think his code was complex because he included test data...

Understood... Such a statement generally means that no value will be...

So... lemme get this straight... you actually have a 4.1 TERAbyte TempDB???  This suggests to me that your code has some real problems and that you grew tempdb to that...

I read through this - and seriously,...

For question #1, just do a test.  I think that you'll find that the stats take a lot longer because Index Rebuilds only affect/rebuild the columns they actually...

Good Lord... I don't know why I went and read some of the resolutions for this list but thanks for bringing it up, Steve.

Read the "Resolution" section for the 3rd...

Heh... what'd I tell ya?  Prelude to SPAM. 😀

Modified to do the group by using the "Timestamp_datetime" field in case someone has the scenario where the time stamp is not already available as a seconds value. I...

Aye... thanks for the feedback.  I've been mostly left out of the update loop at work.  They've got a corporate mandate and it's the Infrastructure Group that takes care of...

Heh... it's still going to be 2 batches... one for the drops and 1 to recover the space that wasn't. 😀

NM

Yep...

Here's the cleaned up test data with a couple of extra rows for the "xx:00" proof...

--    DROP TABLE IF EXISTS dbo.Sell
GO
 CREATE TABLE dbo.SELL...

Hello, so Microsoft has two Feb 2023 SQL updates listed under the same CVE.  5021128 Security update for SQL Server 2016 SP3 Azure Connect Feature Pack+GDR, and 5021129 Security...