What do the scripts actually do?  The reason why I ask is that if there's contention, you could end up with quite a bit of blocking that would make this...

There are some brilliant methods to be had here and are especially necessary because most people's spreadsheets don't actually look like a table.

They also take a special tool and some...

Like I said at one of your previous posts ( https://www.sqlservercentral.com/forums/topic/transaction-log-growth-index-manintenance-jobs-database-functional-jobs#post-4021517 ), there's not much use of it on a busy system because the life=time expectancy of data in that...

I've always been concerned but, as I get older, I seriously worry about the medical world and hospitals and the people in them when I see things like...

"Style" wasn't in the list of BBCodes but tried it in the first post above just to make sure.  Agreed... it doesn't work.

It amazing how many people...

That's a good idea but I don't believe that will reduce the impact on the log file when you use REORGANIZE.

Thank you for the feedback.

Ah... careful now... you can't rely on the default trace on a busy system for things like this.  The lifetime expectancy of any row in our default trace is on...

My...

My two favorite questions are becoming...

1. Is there a reason why this MUST be done in PowerShell?

2. Is there a reason why this MUST be done in Python?

The answer both...

Ok.  I don't actually have any mirrored databases anywhere but I tested this the best...

Advantages of pre-allocation: Queries don't die when you suddenly run out of room in the middle of a transaction. No need to wait for file growth. No risk of...

Step 1 would be to stop using REORGANIZE unless you actually know what it does on each and every index you have and, to be brutally honest, most people don't. ...

Thank you. What will happen if the backup verify fail in one of the database? It will start again taking the backup or just tell us the verify option...