Never mind... I misread some code that was written in a strange fashion.

To be honest, I'd be more worried about code that was using "1000's of DB's in production".  Why do you have so many?  Are you using (for example) one database...

As for reorganize...there are times when that is the only option available, especially when looking at non-Enterprise Editions that are required to be available 7/24/365 - and you cannot...

thanks guys - I forgot about the number of VLF - one would expect that these days where this is well known fact that any DBA has...

If I read this correctly - it seems you are saying that index maintenance needs to be based on that system.  And based upon the data access patterns and...

thanks guys - I forgot about the number of VLF - one would expect that these days where this is well known fact that any DBA has already set...

I'm thinking that Type 6 SCD's may be better.  With that, the use of Temporal Tables may be just what the doctor ordered here with the understanding that they won't...

I agree.  Because there is no requirement for maintaining the order in which the parsed elements appear, String_Split() is the better choice here.

The thing is that you have to be...

I actually ignored her but that, in itself, is a large part of the problem.

BWAAA-HAAAA-HAAAA!  Are you suggesting that I shouldn't tell the DA teen that selfied herself licking the toilet seat on an airliner to suggest that Covid-19 wasn't a big deal that...

For reindexing, the "standard" advice floating around is still to reindex based on logical fragmentation percent.

For a variety of reasons we can get into if necessary, I don't think...

Please post the script if you want an accurate answer.  Otherwise, my suggestion would be to read the following article.

If you actually have SQL Server 2017 or better instead of...

Speaking of hashes, you could create a hash column for all the columns and make that the Clustered PK.  That would certainly be within the limits of a...

Joe... I'm still waiting for you to identify the ISO Standard by number for what you're talking about that clearly identifies that the YYYY-MM-DD format is the only supported format...

Speaking of hashes, you could create a hash column for all the columns and make that the Clustered PK.  That would certainly be within the limits of a CI.