When I was a kid and long before the internet was born, my Dad gave me a piece of advice that applies even more today because of the internet.

"Half of...

If you Google for "call stored procedure from powershell", you'll find some good examples to chose from.

On this website in at the beginning of the 3rd paragraph, we have: "Length for a numeric data type is the number of bytes that...

Getting away from the problems associated with index maintenance in general, you moved to a new machine.  You also have replication of some form going and AG.  IIRC, all of...

Having about 400 hours of testing into index maintenance and discovering many of the problems with it, my first suggestion would be to stop using REORGANIZE except when you KNOW...

I tell people that I'm a database administrator and that I currently take care of and protect about 20 Terabytes of data.  I explain that a Terabyte is a million...

I guess that's the word for it.  They need some paid help especially in the area of some training.

Heh, Phil's name is not, nor ever has been, Sean! And the query was deliberately written in that way, as the OP did not specify the need to see...

DECLARE @RegionCounts Table
(
TYear char(2),
Region varchar(30),
RowCnt int
)

Insert into @RegionCounts values ('13','Latam',100)
Insert into @RegionCounts values ('13','NOAM',200)
Insert into @RegionCounts values ('14','Latam',300)
Insert into @RegionCounts values ('14','NOAM',400)

select * from @RegionCounts

I need...

No pun intended but let's hold the phone for a minute here. 😉

1. What do you want done for hours that have no entries in the table because there were...

Well, that's what I'd like to do! This is so I can keep the scheduling config and T-SQL on one admin SQL Server, whilst the databases reside on different...

I could be wrong but it looks like all of that only covers SQL Server.  If there's something else on the box that's putting the hammer to CPU or file...

I was specifically told during the last update (well prior to this latest migration) that they made a conscious decision to not support any form of...

Ya know... this finally eliminated the confusion I had with this function (mostly because I don't use it but might have better reason to now).  Thanks Steve.

Was it actually due to the partitioning itself or was it because of the preparations (and related indexes) that were actually the key?  I'm asking because in that thread I...