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

If the hierarchies are DAGs (Directed Acyclic Graphs) with no loop backs, no "crossed legs", and are true "Adjacency List" (parent/child only) hierarchies, then I recommend that you study the...

I just wanna know what he actually wants. 😀

#1) In terms of I/O and time, which is faster? running Index Rebuilds or Running Updatestats or is it depens on case to case?

#2) I have a database called...

It shouldn't be too...

Agreed. That would also decide if the last 5 minute period appeared to be in the next hour or not if hourly calculations from the original average calculations needed to...