As a database professional, I see a lot of instructions from vendors on how they want their SQL Server backend configured. Many times, the recommended configuration stinks. It's not their fault - the companies typically don't have anyone on staff whose job it is to lean how to configure each database platform they support for optimum performance.

Today, I came across the opposite situation. I got some recommended SQL Server configurations that were dead-on correct. This was the recommendation:

Do not activate the option "autoshrink" in the database.

And later on, in a different document, there was this:

Do not, by any means, activate the option "autoshrink" in the database.

 

So kudos to you, UC4! You are making DBAs everywhere happy.

 

Share