If it has zero or negative growth, why are you worried about the precise value of an autogrowth number? Pick a number (for example, 50 or 100MB) and move on.

I...

Not quite right.  The ISO standards state that it can look like that as a...

Ola's code is, indeed, the...

Hi

I have the following code:

in the end, the date should look like 1/4/2020, in a date format. And while this appears to be doing that, it comes back with...

Answered my own question. You cant do it that way. Also, you could use an expression task to replace placeholders in a query as long as the max length...

Read my larger post immediately before the short one you responded to.  "It Depends" although I recommend that you simply stop using REORGANIZE except for those things I cited.

p.s.  And stop using REORGANIZE for your index maintenance.  It doesn't work the way most people think (actually sets up indexes for perpetual fragmentation) and it's not the tame little...

I have my production databases set to be "exposed" to the possibility of a transaction log backup every 15 minutes, but it's stupid to do an actual T-Log backup if...

Ola's code is, indeed, the "Gold Standard". ...

Ola's code is great but it doesn't help you if you use the current "Best Practice" (it's not) of blindly rebuilding indexes after you've exceeded 30% logical fragmentation.  Even "Books...

Tony... what is your Cost Threshold of Parallelism set to?

I'm thinking that it means that he tried all 4 settings.

Hi Jeff, I've had some trouble getting your demo working on my home PC.

I installed 32- and 64- bit ACE drivers and then ran this:

sp_configure 'show...

Hello,

I am running a server and I was telling my colleagues that the amount of database has hardly nothing to do with the speed of the server. Basically we...

Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate if it...